Forum Discussion

gwp's avatar
gwp
Icon for Advocate II rankAdvocate II
9 years ago

Get data into Power BI Desktop from Sharepoint Server 2013 On-Premises folder

Hello,   Using latest version of Power BI Desktop, and seeking guidance on the correct method for connecting to several excel files located on sharepoint intranet location.  The organization is run...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Icon for Community Support rankCommunity Support
9 years ago

Hi gwp,

 

Does this Power BI desktop run on the same machine as SharePoint server? When you follow the option suggested by v-yuezhe-msft in this thread, is there any error throws out?

 

Best Regards,
QiuyunYu

 

gwp's avatar
gwp
Icon for Advocate II rankAdvocate II
9 years ago

I'm sorry, we were getting a variety of different errors depending on what url/level of SP we tried to connect at, whioch credentials setting we selected, and which PQ methods we were using. I didn't keep track of the various errors.

 

We ultimately wound up getting it to work like this, Source = Excel.Workbook(Web.Contents("http://xxx/yyy/zzz/abc.xlsx"), null, true), using Windows authentication.