Forum Discussion

TomI8's avatar
TomI8
New Member
1 year ago
Solved

Cannot update the connection references in Power BI APP

Dear user,   My session ID = fad6dcf4-c6de-4721-b238-925651ae590f. I have two types of connection types. One is an SQL Server, which works fine and a Excel file which is in the documents of my b...
Interesting Links
Need Help
Show and Tell
  • andrewsommer's avatar
    andrewsommer
    1 year ago

    What is the source type for the Excel file?

     

    If the Excel file is stored in OneDrive for Business or SharePoint, it must:

    • Be referenced with a web-based URL (starting with https://).
    • Use OAuth2 for authentication (your organizational login).
    • Appear in Power BI under “Web” or “SharePoint Folder” as the source type.

     

    If you reference your excel file using a local or mapped path then Power BI will require an on-premise data gateway, and only windows authentication will be available which will fail if you don’t have a gateway set up.   

     

    Please mark this post as solution if it helps you. Appreciate Kudos.

andrewsommer's avatar
andrewsommer
Icon for Super User rankSuper User
1 year ago

What is the source type for the Excel file?

 

If the Excel file is stored in OneDrive for Business or SharePoint, it must:

  • Be referenced with a web-based URL (starting with https://).
  • Use OAuth2 for authentication (your organizational login).
  • Appear in Power BI under “Web” or “SharePoint Folder” as the source type.

 

If you reference your excel file using a local or mapped path then Power BI will require an on-premise data gateway, and only windows authentication will be available which will fail if you don’t have a gateway set up.   

 

Please mark this post as solution if it helps you. Appreciate Kudos.