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 d...
Need Help
Tips and Tricks
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.

graemeg's avatar
graemeg
Frequent Visitor
5 years ago

Appreciate this post is a few years now.  I was looking to do the same as above.  I solved this, and quickly, setting up the connection in the Power BI desktop and making sure it worked.  I then went into Power Query for the connection and copied the Power Query code from the Advanced Editor into a blank Dataflow.  It worked.