Forum Discussion
Cannot open report using shared dataset 11-12-2020
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
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?
Hi Anonymous,
Currently. power bi desktop uses the signed-in account as the credentials to link live mode power bi dataset.
If you switch the signed-in account or removed the corresponding dataset permissions from the current account, it will show the message as your snapshot displayed.Regards,
Xiaoxin Sheng
That's the thing, I didn't do either of those things. The reports (All shared reports on multiple datasets across multiple workspaces) show that dialogue, then fail to open the 'Select a dataset to create a report dialogue'. Instead they either show a 'Script Error' or disappear, locking up power bI desktop. The only exception is the workaround I posted, after doing that they can be opened normally
Hi Anonymous,
I'd like to suggest go to your workspace dataset setting to check the permissions if someone modifies corresponding dataset settings.
In addition, please also check the limitations of some operations or changes that meet the lists and they may break the dataset connection or usage:
Connect to datasets in the Power BI service from Power BI Desktop#limitations-and-considerations
Regards,Xiaoxin Sheng