Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I'm PBI file is only 1MB in size, and the model is in Star Schema. It has data in import mode (from Excel sheets). I have checked that the visuals on the first page do not take long to load. However, each time I open the file in Power BI Desktop, it takes a long time (over 10 mins). (My machine has 16 GB Ram.) Which area should I look at to improve the performance?
Regards,
Elaine
Solved! Go to Solution.
@elaine_dunwoody , In file option and setting -> Option -> Under Data load, increase Data Cache and management option.
It might 4 GB, Inrease that and check
Hey @elaine_dunwoody ,
in addition to what @amitchandak already pointed out, it seems odd that you have to wait 10min until a 1MB pbix is opened.
Nevertheless, there are certain things happening if you open the file:
The picture below shows what has happened after a ~262 was opened using PBI desktop:
The red rectangle shows that ~262MB has been "expanded" to 2.8GB.
This is ~1GB of the dataset, ~750MB by PBI Desktop, and some visuals, these visuals are represented by the CefSharp.BrowserSubprocess.
This means that it's hard to guess the time to open and RAM consumption from the physical file size.
The above-mentioned file opens in ~40sec on my machine (thinkpadx13 gen1, i7, 16GB of RAM).
I recommend adding an empty page and make this page the active page, close the file, and reopen. Then watch the task manager, you will see the processes that take time.
My assumption is that you are using some calculated columns, it's always a good idea to use Power Query to create these columns, this of course will not shorten the time if a data refresh is happening, but should shorten the time if you "just" open the pbix.
Without the pbix, it's difficult to say what's eating up the time.
Hopefully, this provides some ideas on how to tackle your issue.
Regards,
Tom
Hey @elaine_dunwoody ,
in addition to what @amitchandak already pointed out, it seems odd that you have to wait 10min until a 1MB pbix is opened.
Nevertheless, there are certain things happening if you open the file:
The picture below shows what has happened after a ~262 was opened using PBI desktop:
The red rectangle shows that ~262MB has been "expanded" to 2.8GB.
This is ~1GB of the dataset, ~750MB by PBI Desktop, and some visuals, these visuals are represented by the CefSharp.BrowserSubprocess.
This means that it's hard to guess the time to open and RAM consumption from the physical file size.
The above-mentioned file opens in ~40sec on my machine (thinkpadx13 gen1, i7, 16GB of RAM).
I recommend adding an empty page and make this page the active page, close the file, and reopen. Then watch the task manager, you will see the processes that take time.
My assumption is that you are using some calculated columns, it's always a good idea to use Power Query to create these columns, this of course will not shorten the time if a data refresh is happening, but should shorten the time if you "just" open the pbix.
Without the pbix, it's difficult to say what's eating up the time.
Hopefully, this provides some ideas on how to tackle your issue.
Regards,
Tom
@elaine_dunwoody , In file option and setting -> Option -> Under Data load, increase Data Cache and management option.
It might 4 GB, Inrease that and check
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
98 | |
80 | |
67 | |
63 |
User | Count |
---|---|
145 | |
111 | |
104 | |
84 | |
64 |