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
webportal's avatar
webportal
Icon for Impactful Individual rankImpactful Individual
6 years ago

Basically, I can read from a Sharepoint folder in Power BI Desktop and copy/paste the code to the flow.

Does not work directly in the flow, I have no idea why.

Thanks anyway for helping!

😀

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.