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.
Any help will be kindly appreciated.
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?
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.
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.
Check out new user group experience and if you are a leader please create your group!
On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks
Check out how to claim yours today!