Forum Discussion
Power BI Service error connecting to an excel database from Sharepoint
Hi chauh-dp Ensure you are using the correct file URL, formatted as https://<tenant>.sharepoint.com/sites/<SiteName>/Shared Documents/<FileName>.xlsx, without the ":x:/r" or query strings. Grant appropriate permissions to the file for your colleagues to access it. Use the "SharePoint Online List" connector in Power BI for authentication via an organizational account. Lastly, test the connection in Power BI Desktop and republish the report, ensuring the credentials are correctly set in the Power BI Service Data Source Settings.
Hi chauh-dp ,
Thanks for reaching out to the Microsoft fabric community forum.
1. Get the Correct File Path from SharePointGo to the document in SharePoint (via your browser).
Click the “...” (more options) - choose “Details” or “Copy link”.
You’ll get a link that looks like this:
This is not valid for Power BI.
Convert it into a valid Web URL like this:
https://yourtenant.sharepoint.com/sites/TeamSite/Shared%20Documents/Folder/File.xlsx
Remove : x : / r
Remove everything after .xlsx
Replace spaces with 20%.2. Use Web Connector in Power BI Desktop (not Excel connector)
Open Power BI Desktop
Go to Home - Get Data - Web
Paste the corrected SharePoint URL:
https://yourtenant.sharepoint.com/sites/TeamSite/Shared%20Documents/Folder/File.xlsxWhen prompted, authenticate using "Organizational Account" and sign in.
3. Publish the Report to Power BI Service
Go to the Power BI workspace
Click on the dataset (semantic model) - Settings
Under Data Source Credentials, re-authenticate using Organizational Account
Enable Scheduled Refresh
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it
Best Regards,
Sreeteja.
Community Support TeamHi chauh-dp ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solution and give a 'Kudos'. This will be helpful for other community members who have similar problems to solve it faster.
Hi chauh-dp ,
Thanks for reaching out to the Microsoft fabric community forum.
1. Get the Correct File Path from SharePoint
Go to the document in SharePoint (via your browser).
Click the “...” (more options) - choose “Details” or “Copy link”.
You’ll get a link that looks like this:
Convert it into a valid Web URL like this:
https://yourtenant.sharepoint.com/sites/TeamSite/Shared%20Documents/Folder/File.xlsx
Remove everything after .xlsx
Replace spaces with 20%.
2. Use Web Connector in Power BI Desktop (not Excel connector)
Open Power BI Desktop
Go to Home - Get Data - Web
Paste the corrected SharePoint URL:
https://yourtenant.sharepoint.com/sites/TeamSite/Shared%20Documents/Folder/File.xlsx
When prompted, authenticate using "Organizational Account" and sign in.
3. Publish the Report to Power BI Service
Go to the Power BI workspace
Click on the dataset (semantic model) - Settings
Under Data Source Credentials, re-authenticate using Organizational Account
Enable Scheduled Refresh
If the response has addressed your query, please Accept it as a solution and give a 'Kudos' so other members can easily find it
Best Regards,
Sreeteja.
Community Support Team
Hi chauh-dp ,
May I ask if you have resolved this issue? If so, please mark the helpful reply and Accept it as the solution and give a 'Kudos'. This will be helpful for other community members who have similar problems to solve it faster.