Forum Discussion

jeppesal's avatar
jeppesal
Advocate II
9 years ago

Power BI refresh hijacks credentials from Excel Online

I have an Excel file that loads data from Azure SQL DB (through Power Query and Power Pivot). The problem is that when I configre a resfresh with Power BI Service all other users (except my self) is no longer able to refresh the file in Excel Online.

I have done the following:
   1. Created a Power BI Group/Workspace
   2. Uploaded the Excel fil to the groups OneDrive (or Sharepoint folder?)
   3. Given all members admin permissions in the Power BI workspace and explicit Full permission on the Excel file in the    Sharepoint folder.


At this point the manuel refresh in Excel Online works!

 

   4. Now I configure automated refresh i Power BI and enters the basic credentials to Azure SQL DB on the data source.
   5. The automated refresh works but now the manuel refresh in Excel Online stops working for everyone except my self.

 

This is the error and i comes for every table.

 

My theory is that Power BI somehow hijacks the connection or at least the credentials used by the connection.

Need Help

5 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Community Support
    9 years ago

    Hi jeppesal,

     

    I already involved someone more familiar with this topic for a further look at this issue. Your patience is greatly appreciated. 


    Thank you for your understanding and support.

     

    Best Regards,
    Qiuyun Yu

    • jeppesal's avatar
      jeppesal
      Advocate II
      9 years ago

      Hi Qiuyun_Yu,

       

      Thank you for taking action, I will wait for any news.

       

      Best Regards,

      Jeppe

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Community Support
        9 years ago

        Hi jeppesal,

         

        I have gotten confirmation from our Product Group that this is working as designed. In case when User1 defines the credentials in Power BI and User2 does the refresh, we use User1’s refresh token to do the refresh.  In case of refresh from SharePoint (OneDrive), it isn't aware of User1’s refresh token and calls Power BI with User2’s identity.

         

        If you have any further questions on this, please let me know.

         

        Best Regards,
        Qiuyun Yu