Forum Discussion

vehau1's avatar
vehau1
Helper I
7 years ago

Dataflows: Import from Sharepoint folder

 

I want to gather all my dataflows in one app space. Part of this data is an Excel Workbook that's placed in a Sharepoint page that I own.

 

I want to connect to and import this Excel file as a dataflow. However, I cannot choose "Sharepoint Folder" as my Data Source choice. Do you have any clues as to what I can do to get this file as part of my dataflow?

 

Thanks.

Need Help
Tips and Tricks

14 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    7 years ago

    Hi vehau1,

     

    There may be occasions when connecting to data sources for dataflows run into issues. This section provides troubleshooting tips when such issues arise.

    • Salesforce connector - Using a trial account for Salesforce with dataflows results in a connection failure with no information provided. To resolve this, use a production Salesforce account or a developer account for testing.

    • SharePoint connector - Make sure you supply the root address of the SharePoint site, without any subfolders or documents. For example, use link similar to the following: https://microsoft.sharepoint.com/teams/ObjectModel.

     

    Reference: https://docs.microsoft.com/en-us/power-bi/service-dataflows-create-use.

     

    Regards,

    Jimmy Tao

    • vehau1's avatar
      vehau1
      Helper I
      7 years ago

      Thank you for the response.

       

      Regarding your Sharepoint address, I am aware of this. I am able to use the connector "Sharepoint Online List" to import the list of objects that holds information in place on my Sharepoint Site, providing the URL to the site as you described.

       

      However, I can't get the actual files stored on the Sharepoint site unless I use the "Sharepoint Folder" connector

      This connector, "Sharepoint Folder", isn't even available in the "Get Data"-area when I try to create a new entity. So I'm stuck.

      • Veles's avatar
        Veles
        Advocate V
        7 years ago

        vehau1

         

        I've managed to find a workaround. Select Blank Query and then enter the below as the source. Click next and you can go from there. You would just enter the URL that you would normally do when you select SharePoint Folder in the desktop version.

         

        Source = SharePoint.Files("https://[YOURSITE].sharepoint.com/sites/[YOUR SITE]/", [ApiVersion = 15])

        It looks like it's a bit cut down though so there's no button to automatically combine files together as you can in desktop.

         

        EDIT: Managed to get the file combination working with a bit of tweaking - I found it easier to create the query and desktop then copy the whole lot over into a blank query.