![]() Hopefully, this provides some ideas on how to tackle your issue. Without the pbix, it's difficult to say what's eating up the 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. Now open MS Word and enjoy writing Additional help: If after performing the above, the Word is still slow when launching or closing then restore it to its default settings by following the steps below: a. Then watch the task manager, you will see the processes that take time. Next time you open MS Word, a new, clean Normal Template (Normal.dot, Normal.dotm), will be created. I recommend adding an empty page and make this page the active page, close the file, and reopen. The above-mentioned file opens in ~40sec on my machine (thinkpadx13 gen1, i7, 16GB of RAM). This means that it's hard to guess the time to open and RAM consumption from the physical file size. This is ~1GB of the dataset, ~750MB by PBI Desktop, and some visuals, these visuals are represented by the CefSharp.BrowserSubprocess. The red rectangle shows that ~262MB has been "expanded" to 2.8GB. The picture below shows what has happened after a ~262 was opened using PBI desktop: the dataset is loaded from your drive into the memory.Nevertheless, there are certain things happening if you open the file: Hey addition to what pointed out, it seems odd that you have to wait 10min until a 1MB pbix is opened.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |