Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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.
Solved! Go to 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.
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 ;). |
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. | Proud to be a Super User! |
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.
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 ;). |
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. | Proud to be a Super User! |
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 ;). |
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. | Proud to be a Super User! |