Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
The reports for one of our powerBi dashboards are not loaded. The error when opening the reports is below. Please help!!!
It should be because the user doesn't have the access to the conection.
In my case I'm using power BI conected to MSAS, and the same message appears when I share the report.
The solution that i found was giving access tho the user on Analysis Service DB:
- Open SQL Server Management Studio
- Conecto to Analysis Services
- Expand your DB
- Go to Roles
- Modify or create roles giving acces to the user(s)
After this changes the users can open the reports with no problems.
Hope this will helpfull.
Regards.
Any help will be kindly appreciated.
Thank you.
Hi,
i had similar situation with SSAS Tabular connector. What I did to workaround this issue, I saved my pbix file with different name and uploaded it to Power BI service.
I noticed that automatically my pbix file changes size multiple times i.e. it was much smaller.
I had the same issue and it started when I created a fairly complex page in a report. I removed the page, republished, and it started working again. I re-added the page and the whole report fails again. It feels like there is a setting under the covers we don't have control over.
This page had a matrix with totals, PrevYr, and variance over 3 years for 20k customers. That seemed to kill it. A memory issue perhaps?
I'm getting the same error...this can't be a production system until they get this stuff figured out
try to delete your existing report in PowerBI.com, open it the tool that you used to create it (Excel or Desktop), make sure that you can open it there and then publish it again.
Im hesitant to delete my report as it means I have to recreate my dashboard.
There must be another way
I am getting the exact same error. Tried downloading the personal gateway again but still didn't help. This needs to be fixed!!!
In general, the members of this forum at not able to troubleshoot these kinds of issues. Your best bet is to send a "frowny face" when in the Service. It is the smiley face icon in the upper right. It allows you to describe the problem and take a screen shot. I have had VERY GOOD success when using this feedback mechanism. I generally receive a very timely reply from the support team.