Forum Discussion

nbs33's avatar
nbs33
Icon for Helper II rankHelper II
4 years ago
Solved

Cannot 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...
Need Help
  • nbs33's avatar
    nbs33
    4 years ago

    Update: I ended up running the model in an AWS EC2 virtual machine. Not ideal but at least it works. 

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi

  Whats your Datamodel size ? Huge dataset creates problems, see if you can tune the model a bit to reduce the size.

  • Remove the unnecessary columns and filter the unwanted data - This seems to be simple, but its very  effective. 
  • Make sure auto date time option is disapled. Every date field in the model creates a hidden data table.
  • Disable load of the tables which are not needed in the report panel.

The list goes on. 

 

Thansk
Raj

  

nbs33's avatar
nbs33
Icon for Helper II rankHelper II
4 years ago

Thanks for the response Anonymous. It's only 7 mb. I assumed it was much bigger because it has been very slow since day one and it is downloading many company ledgers. 

 

I can't see the error message because it crashes my computer before an error is shown. Any ideas what it could be?