Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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

  • Anonymous's avatar
    Anonymous
    Not 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.

    • Anonymous's avatar
      Anonymous
      Not 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

      • Anonymous's avatar
        Anonymous
        Not 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?