Forum Discussion

webportal's avatar
webportal
Icon for Impactful Individual rankImpactful Individual
6 years ago

How to read the files from a Sharepoint folder?

Hello,   I'm trying to create a dataflow in Power BI Service to connect to a sharepoint folder.   When typing the root name of the site I get a blank editor:   But when trying to type the...
Need Help
v-lionel-msft's avatar
v-lionel-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi webportal ,

 

Maybe you can try again by following these steps:

1. Choose data source "SharePoint folder":

2. Input the URL (You can copy it in the browser address bar ) and credentials:

(The format of Site URL: https://domain_name.sharepoint.com/sites/site_name)

3. Combine the files:

 

Best regards,
Lionel Chen

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

webportal's avatar
webportal
Icon for Impactful Individual rankImpactful Individual
6 years ago

Hi v-lionel-msft 

It doesn't work for me.

On your step 3, after carefully entering the URL, I get a blank query.

 

I've noticed that on the query I've copied from Power BI Desktop, the "Source" step, is like:

 

SharePoint.Files("https://xxx.sharepoint.com/sites/yyy", [ApiVersion = 15])

 

And this one works.