Forum Discussion

diskovered's avatar
diskovered
Helper III
7 years ago
Solved

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 curiou...
Need Help
  • diskovered's avatar
    diskovered
    7 years ago

    It works in Advanced Editor using source = Sharepoint.Files ()

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

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

  • diskovered's avatar
    diskovered
    Helper III
    7 years ago

    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? 

    • diskovered's avatar
      diskovered
      Helper III
      7 years ago

      It works in Advanced Editor using source = Sharepoint.Files ()