Forum Discussion
Cannot open report using shared dataset 11-12-2020
Hey guys,
Yesterday morning I tried to open one of our reports using a shared dataset, and it failed to open with this error:
I have sufficient permissions, and the dataset exists, but I cannot open the report that connects to it. When I click retry the error persists, and when I hit edit or cancel, Power BI desktop disappears from the screen.
I tried disabling the security checks enabled in the newest update, but that had no effect. Any ideas?
6 Replies
- AnonymousNot applicable
Update: I was finally able to trigger the 'Select Dataset' Dialogue to open by launching power BI without a report, then opening the report with a shared dataset from the side. The same error appears, but now retry opens the dialogue.
Once I went through this process and saved the report, I could launch it from file explorer normally. This is 100% a work around though. Does anyone have insight into what might have caused this? Reports with built in datasets are not acting this way.
Additional Info: these same reports are now blank in Power BI Pipelines. The prod workspace is fine, but both dev and test completely fail to render their copies of these reports.- AnonymousNot applicable
HI Anonymous,
It seems like you are working with a report that 'live connection' to the shared dataset, right? If this is a case, have you test with multiple credentials in your report?
AFAIK, current power bi will cache the credentials into the local and it not support using multiple credentials with the same Datasource types. (new credentials will replace the previous one and the data source tables who use the old credentials will be failed to load)
In addition, can you please share more detailed information about your operations?
How to Get Your Question Answered Quickly
Regards,
Xiaoxin Sheng
- AnonymousNot applicable
Thanks for checking in!
I am using a report with a 'Live connection' to a power BI Shared dataset.
There are not Multiple credentials.
What details would be beneficial?