PL-300 · Question #470
You have a Power BI report named Report that contains the following tables. For the last three days, refresh in Power BI has failed, and you receive the following error message: "You have reached…
The correct answer is D. Change the invoice table to a composite table that contains historical data as a DirectQuery table. The problem is related to the size of the Invoice table. Only hot data need to be held in memory (RAM). The DirectQuery with historical data will not Note: With DirectQuery, users can create data models that span multiple tables or even multiple data sources and perform…
Question
You have a Power BI report named Report that contains the following tables. For the last three days, refresh in Power BI has failed, and you receive the following error message:
"You have reached the maximum allowable memory allocation for your tier. Consider upgrading to a tier with more available memory." You need to resolve the error and ensure that query response times are minimized for end users. What should you do?
Exhibit
Options
- AMerge the Sales person and invoice tables based on the SalesPersonId column.
- BChange the invoice table to a DirectQuery table and read the data live from the source, retaining
- CReduce the size of the invoice table by summarizing sales by Product, Sales person, Calendar,
- DChange the invoice table to a composite table that contains historical data as a DirectQuery table
How the community answered
(32 responses)- A3% (1)
- B13% (4)
- C9% (3)
- D75% (24)
Explanation
The problem is related to the size of the Invoice table. Only hot data need to be held in memory (RAM). The DirectQuery with historical data will not Note: With DirectQuery, users can create data models that span multiple tables or even multiple data sources and perform real-time analysis of the source data. Since the data is not imported into Power BI, there is no need to refresh the data manually, as the data is always up to date.
Community Discussion
No community discussion yet for this question.