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.
Hi there, I have SharePoint on-prem installed and trying to follow this tutorial:
https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
I'm curious if SharePoint folder is only compatible with SharePoint online (sharepoint.com) at the moment? I haven't been able to connect to our SharePoint on-prem using SharePoint folder as data source.
Solved! Go to Solution.
It works in Advanced Editor using source = Sharepoint.Files ()
Hi @diskovered,
I'm curious if SharePoint folder is only compatible with SharePoint online (sharepoint.com) at the moment? I haven't been able to connect to our SharePoint on-prem using SharePoint folder as data source.
We could get data with SharePoint Folder connector from SharePoint on-premises. The way should be similar with that get data from SharePoint online.
From this similar thread, please make sure that you are entering the site URL of your SharePoint site in Power BI Desktop and use Windows authentication when get data from SharePoint on-prem .
Best Regards,
Cherry
Hi there, thank you for answering.
My on-prem sharepoint address is: http://mysp
I tried everything: https://mysp, http://mysp/, unc (\\mysp),
Amy I missing something? What is the difference between SharePoint link vs URL?
It works in Advanced Editor using source = Sharepoint.Files ()
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 |
---|---|
114 | |
99 | |
82 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |