Forum Discussion
Material View for Summary Table
My ultimate goal is to create a profit and loss statement for my company from our many datasources. The problem that I am running into is that the Profit and Loss visual takes a long time to load an...
Hi JoeMac
To my knowledge, if you create a calculated table as a summary table with DAX and use data from this calculate table to populate visuals, the DAX queries from these visuals will be sent to the calculated table instead of the data sources, which should make interaction faster. However, a calculated table is in Import mode not DirectQuery, so it will not always be updated automatically to have real-time data from the data sources. You need to execute refresh manually or set up a scheduled refresh in Power BI Service to update the data in the summary calculated table.
Best Regards,
Jing