Forum Discussion

webportal's avatar
webportal
Impactful 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
Community Support
6 years ago

Hi webportal ,

 

The problem should be on the sharepoint link.

Make sure you supply the root address of the SharePoint site.

Please refer to the video in this document that how to get the sharepoint link.

https://docs.microsoft.com/en-us/power-bi/desktop-sharepoint-online-list 

 

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
    Impactful Individual
    6 years ago

    v-lionel-msft thanks for your help.

     

    The root address of the Sharepoint site is correct.

    • webportal's avatar
      webportal
      Impactful 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
        Community 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.