Forum Discussion

cca's avatar
cca
Regular Visitor
9 years ago
Solved

Connect Power Bi to Sharepoint on premise using Get Data

We are have an on Premise 2013 Sharepoint. we want to connect Power Bi destop to the Sharepoint sites in order to access excel files. We have tried using the root directory url, the folder directory ...
  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    9 years ago

    Hi cca,

     

    Does the Power BI desktop run on the same server which hosts the SharePoint? If not, are those two servers in the same server and can communicate each other?

     

    In your scenario, please follow v-yuezhe-msft's suggestion to get data from the Excel in on-premise SharePoint: SharePoint On Premise Connection to Excel File. As it's on-premise SharePoint, please select Windows authentication, if current Windows credential doesn't have permission to access this Excel, please enter alternate credential when get data.

     

    Make sure you run the latest desktop version 2.45.4704.722.

     

    Best Regards,
    Qiuyun Yu

     

Nolan's avatar
Nolan
Regular Visitor
8 years ago

I had the same issue but using windows authentication or entering credentials did not work for me. I connected to SharePoint using File Explorer and was promted for authentication. After it was entered and I could use File Explorer to browse content on the server I went back to Power BI and connected without issue.