PL-300 · Question #278
You use Power BI Desktop to load data from a Microsoft SQL Server database. While waiting for the data to load, you receive the following error. You need to resolve the error. What are two ways to…
The correct answer is A. Split log running queries into subsets of columns and use Power Query to merge the queries. C. Reduce number of rows and columns returned by each query. The error is a query timeout caused by a long-running query against SQL Server. Option A resolves this by splitting the query into smaller column subsets, each of which completes within the timeout window; Power Query then merges the results locally. Option C resolves it by…
Question
You use Power BI Desktop to load data from a Microsoft SQL Server database. While waiting for the data to load, you receive the following error. You need to resolve the error. What are two ways to achieve the goal? Each correct answer presents a complete solution. NOTE: Each correct selection is worth one point.
Options
- ASplit log running queries into subsets of columns and use Power Query to merge the queries.
- BDisable query folding on long running queries
- CReduce number of rows and columns returned by each query.
- DUse Power Query to combine long running queries into one query.
How the community answered
(35 responses)- A77% (27)
- B9% (3)
- D14% (5)
Explanation
The error is a query timeout caused by a long-running query against SQL Server. Option A resolves this by splitting the query into smaller column subsets, each of which completes within the timeout window; Power Query then merges the results locally. Option C resolves it by reducing the volume of data returned (fewer rows and columns), so each query executes faster and within the timeout limit. Option B (disabling query folding) would force processing into the Power Query engine instead of SQL Server, making queries slower and worsening the timeout. Option D (combining long-running queries into one) increases the workload per query, making timeouts more likely, not less.
Community Discussion
No community discussion yet for this question.