Forum Discussion
SharePoint folder using SharePoint on-prem
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.
It works in Advanced Editor using source = Sharepoint.Files ()
3 Replies
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 ()
