PL-300 · Question #402
You have a Power BI semantic model that contains four queries named Query 1, Query2. Query3, and Query4. Query1 loads customer data into the model and is referenced by the other three queries. You…
The correct answer is C. Reconfigure Query1 as a dataflow entity. https://learn.microsoft.com/en-us/power-bi/guidance/power-query-referenced-queries In the example, if Query1 is redesigned as a dataflow entity, Query2, Query3, and Query4 can use it as a data source. With this design, the entity sourced by Query1 will be evaluated only
Question
You have a Power BI semantic model that contains four queries named Query 1, Query2. Query3, and Query4. Query1 loads customer data into the model and is referenced by the other three queries. You discover that data refresh for the model is slow. You need to improve the data refresh time. The solution must minimize costs. What should you do?
Options
- ARun the Table.buffer function in Query1.
- BDuplicate Query1 to all the other queries.
- CReconfigure Query1 as a dataflow entity.
- DFrom the Power BI Admin portal, increase the Capacity settings.
How the community answered
(28 responses)- A4% (1)
- B7% (2)
- C79% (22)
- D11% (3)
Explanation
https://learn.microsoft.com/en-us/power-bi/guidance/power-query-referenced-queries In the example, if Query1 is redesigned as a dataflow entity, Query2, Query3, and Query4 can use it as a data source. With this design, the entity sourced by Query1 will be evaluated only
Community Discussion
No community discussion yet for this question.