I am able to access single file but not a folder in sharepoint.

[Anonymous]

Hi,

By using web to get data I am able to pull in single excel file from sharepoint in Power BI. But when I am trying to fetch a sharepoint folder I am getting nulls as shown in the image. All the files and folder is shared to me by the author. I couldn't figure out the cause of this.  

[v-jingzhang]

Hi @Anonymous 

I'm afraid the URL you passed is not in the correct format. When you use SharePoint Folder connector, you need to pass the SharePoint site URL rather than the folder URL to it. It doesn't have "-my" either. For example,

Please refer to this official doc: Power Query SharePoint folder connector - Power Query

In addition, I believe this detailed article should be helpful: Get Data from OneDrive or SharePoint with Power Query • My Online Training Hub

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[KNP · Accepted solution]

Hi @Anonymous,

It could have something to do with how it is shared.

This may not work, but can you try changing the [ApiVersion = 15] to [ApiVersion = 14].

Let me know if that helps.

[Anonymous]

Hey thanks. It worked. How this makes sense anyways??

[KNP]

Version 14 of the API returned columns in a slightly different way. I'm not sure if any of the optional settings for ApiVersion 15 would do the same thing but if 14 is working, stick with that for now.

I'm glad that helped.