Forum Discussion
Connect Power Bi to Sharepoint on premise using Get Data
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
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
Hi v-qiuyu-msft The Power BI run on a different server from the Sharepoint server. But they are in the same domain and can communicate to each other. I have tried option 2 and I still get permission error.
Hi cca,
As you mentioned you have tried the option 2, what's the result when you type the SharePoint site root URL in browser on the server Power BI desktop runs?
How about the result when you try the option 1?
Best Regards,
Qiuyun YuHi v-qiuyu-msft,
When i tried the 2 option i get the error "Access to the resource is fobidden".
When I tried the 1 option, it was successful, I was able to conenct to the excel file.
I dont understand why I get the permission error with the 2 option
