Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am getting below error while connecting excel files on Sharepoint location. I can manually access all the files but Sharepoint Folder is throwing below error. Please advice:
Solved! Go to Solution.
It seems you didn't use the correct connector or enter a valid URL with the correct format.
If you want to connect to a single Excel file stored in Sharepoint online, copy its link from Sharepoint online and use Get data > Web in Power BI Desktop. It's similar to connect to an Excel file stored in OneDrive for Business.
Use OneDrive for Business links in Power BI Desktop
If you want to connect to a Sharepoint folder which contains multiple Excel files and hope to combine them into one, you can use the SharePoint Folder connector. Paste the address into the Site URL text box in the SharePoint folder dialog box, which is similar to https://contoso.sharepoint.com/marketing/data.
Power Query SharePoint Folder connector
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
It seems you didn't use the correct connector or enter a valid URL with the correct format.
If you want to connect to a single Excel file stored in Sharepoint online, copy its link from Sharepoint online and use Get data > Web in Power BI Desktop. It's similar to connect to an Excel file stored in OneDrive for Business.
Use OneDrive for Business links in Power BI Desktop
If you want to connect to a Sharepoint folder which contains multiple Excel files and hope to combine them into one, you can use the SharePoint Folder connector. Paste the address into the Site URL text box in the SharePoint folder dialog box, which is similar to https://contoso.sharepoint.com/marketing/data.
Power Query SharePoint Folder connector
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
@FaisalBaloch ,refer this past solution
https://community.powerbi.com/t5/Desktop/Error-connecting-to-Sharepoint-Online/m-p/1461133
also check this
https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |