Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Reports having composite model do not open with PowerBI Desktop October and November (2.111.590.0 64-bit) releases. Same reports open with earlier versions (e.g. September).
Symptoms: Opening report just hangs presenting the startup screen. No error messages. Currently experimenting with November release and opening has been continuing for about 1 hour now. Windows task manager shows 0% CPU (for PowerBI) and 12-13% for Microsoft Analysis Services.
The same reports work still in PowerBI Pro and Premium capacity (as an app) - and with September version of Desktop.
Reports having this issue are using composite model (storage mode: Mixed):
1. direct connection to SQL Server Analysis Services database (PowerBI datamodel)
2. import of local files
3. import using DAX query from the same SQL Server Analysis Services database having the direct connection (to create couple of needed code tables).
4. added local columns on a table using direct connection
5. measures both in corporate model and local model
Note: depending on the report it may use 1&2&5 or 1&4&5 or 1&2&3&5.
Creating a new report from scratch using composite model works and so do old reports using either import or live connection to the same SQL Server Analysis Services database described above.
What I have done to solve the problem:
1. Removed and reinstalled different versions of PowerBI desktop
2. Tested with and without Webview2 (with October PowerBI desktop)
3. Tested by waiting long time (hour?) for a report to open.
4. Downloaded PowerBI desktop report file from Premium (guessing that file might be "rebuild" during the process)
5. Only solution is to uninstall new PowerBI desktop version (October or November) and install old version (September). Based on this problem is not on my environment but on PowerBI desktop version.
Similar issue has been reported 6.11.2022 (11/6/2022) by @ANTOS post Issues with latest release of Power BI (October 2022 Update (2.110. 341.0))
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @AJH
I am so glad to hear that your issue has been fixed . Thanks for your reply .
Best Regards,
Community Support Team _ Ailsa Tao