Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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

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.  

mayur_abnave_0-1667820672274.png

 

1 ACCEPTED SOLUTION
KNP
Super User
Super User

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.

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x

View solution in original post

4 REPLIES 4
v-jingzhang
Community Support
Community Support

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,

vjingzhang_0-1667900299020.png

 

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
Super User
Super User

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.

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x
Anonymous
Not applicable

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

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. 

 

Have I solved your problem?
Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;).
chrome-9xf-Zagzel-B

If you found this post helpful, please give Kudos.
It gives me a sense of instant gratification and, if you give me Kudos enough times, magical unicorns will appear on your screen.
If you find my signature vaguely amusing, please give Kudos.
KIfp67uy-Sr
Proud to be a Super User!PBI-Super-User-Rank-30x30-1x

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.