Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

Retrieve data from specific sharepoint folder with Power BI

Hi, 

 

I want to create a sharepoint folder connection in order to update the data in a Power Bi dashboard. In my sharepoint sites I have 3 folders, and each of them contain different files. I do these steps in power query:

 

Here I am prompted to enter the base URL of my sharepoint site (it is named folder though...), how can I get the URL I need to connect to my "Test1" folder? The folder structure can be seen below. The "Home" URL is: https://sites.XXXX.com/sites/LEKNR2.

 

 

1 Reply

  • christinepayton's avatar
    christinepayton
    Most Valuable Professional
    2 years ago

    The connector connects at the site level, you can then filter down the files to a specific folder using the "path" column in the returned data table. 

     

    If your files have substantially different structures and you're not trying to combine them in a single table, you may need to do multiple connections to the same site to bring them all in.