Search code examples
powerbipowerquerypowerbi-desktoppowerbi-datasource

Retrieve data from specific sharepoint folder with Power BI

I am trying to enter a new source, which is data in a folder in a sharepoint site. These are my folders: sharepoint structure

I take these steps:

Select sharepoint folder

My sharepoint site has three (I want to add more later) folders in it's documents. I want to select which folder to look in -> in this case it's test "Test1" folder.

How can I select the folder? The site URL field is prompting me to use the root site URL, but then it retrieves data from all the folders? Sharepoint prompt URL

Solution

  • I'm glad to hear you solved the problem. I would make a brief summary of this thread:

    Issue Symptom:

    Retrieve data from specific Sharepoint folder with Power BI,The site URL field is prompting me to use the root site URL, but then it retrieves data from all the folders?

    Current status:

    The issue has been solved. The solution is using SharePoint.Contents() retrieve.

    In case the link doesn't work, I've taken a screenshot of the joint steps involved:

    enter image description here

    enter image description here