Forum Discussion

hyggins's avatar
hyggins
Icon for Helper I rankHelper I
8 years ago
Solved

Power BI Desktop Excel Online Datasource failing

I have an existing report which, until today, was working perfectly. I typically create reports in Desktop and publish to Services. A change request came through so I loaded the report in Desktop to ...
  • Anonymous's avatar
    Anonymous
    8 years ago

    hyggins,

    Do you connect to Power BI Service dataset using Power BI Service connector in Power BI Desktop ? Or you are editing the original PBIX file which you have published to Power BI Service?

    If you are editing the original PBIX file, backup the PBIX file, then delete the data source (File->Options and Settings->Data Source Settings->Clear Permission) and reconnect(File->Options and Settings->Data Source Settings->Edit Permission) to see if it works.

    Regards,
    Lydia

Anonymous's avatar
Anonymous
Not applicable
8 years ago

hyggins,

Do you connect to Power BI Service dataset using Power BI Service connector in Power BI Desktop ? Or you are editing the original PBIX file which you have published to Power BI Service?

If you are editing the original PBIX file, backup the PBIX file, then delete the data source (File->Options and Settings->Data Source Settings->Clear Permission) and reconnect(File->Options and Settings->Data Source Settings->Edit Permission) to see if it works.

Regards,
Lydia

hyggins's avatar
hyggins
Icon for Helper I rankHelper I
8 years ago

Hello Anonymous,

 

Thank you for the reply. I am editing the original PBIX file. I was able to test this morning and the steps you detailed brought back the credential prompts. Using my Organization credentials I connected successfully to the Excel file in my OneDrive for Business folder.

 

Thanks again!

  • anhnguyenhoang's avatar
    anhnguyenhoang
    Frequent Visitor
    7 years ago

    Hi,

    I have faced the same issue with this topic, however when I clear permission and tried to connect with the organisational credentials I stil have the same notification error.

    Any suggestion please ?

  • anhnguyenhoang's avatar
    anhnguyenhoang
    Frequent Visitor
    7 years ago

     

    Hello, 

    I'm getting the same error, as I have been tried to clear permission and log in again with my credentials but still not working.

    Any suggestion?

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello,

       

      the same problem here - it didn´t solve the problem to clear the permission.

       

      Are there any other solutions?

       

      Thank you