Cannot open report using shared dataset 11-12-2020

[Anonymous]

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?

[Anonymous]

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.

[Anonymous]

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

[Anonymous]

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?

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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