Forum Discussion
nbs33
Helper II
Helper IICannot apply changes
Hi, I have inherited a Power BI dashboard that someone else made. The data model is very complex and takes an extremely long to load. I have been asked to make minor changes and when I try to app...
Update: I ended up running the model in an AWS EC2 virtual machine. Not ideal but at least it works.
Hi nbs33 ,
What changes did you apply to the queries? What data sources did you connect to? What is the connection type(Import/Direct Query/Live connection)? First, you can refer to the following official document to optimize your model according to its connection type.
Optimization guide for Power BI
Also, you can check the methods provided in the link below, hopefully they will help you and give you some ideas or insights.
Performance Tip for Power BI; Enable Load Sucks Memory Up
Power BI Unable to Apply Query Update
Data Privacy Settings In Power BI/Power Query, Part 1: Performance Implications
Best Regards