Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
I wonder if anyone can help.
I am trying to get to the meta data of a libaray within SharePoint when connecting in PBI, I am presented with an error saying the URL isn't valid and I should only proivde the root url, however, when I do this I can only get meta data from the top level of folders. The library I want the meta data for is in a sub folder.
Thanks
Hi @Anonymous ,
How did you connector to that datasource? Web connector or sharepoint connector? Can you confirm you have correspond permissions to access these files?
In addition, if you are working with web connector. You can try to add 'relative path' option to split original url to root path and relative path.
Using The RelativePath And Query Options With Web.Contents() In Power Query And Power BI M Code
Regards,
Xiaoxin Sheng
Hi @Anonymous ,
I do have permission to access the files. I have predominatly been trying to connect via the Sharepoint connectors. Which is where I can only access folders at the top level.
The when I have tried the web connector this morning I get an unable to connect error.
hi @Anonymous ,
>> I have predominatly been trying to connect via the Sharepoint connectors. Which is where I can only access folders at the top level.
Power bi not atuto inherit parent level permission to its child, you need to confirm you have permission to operation detail level files.
Regards,
Xiaoxin Sheng
I do have permission within sharepoint to view all folders.
It is just within Power BI I can only work out how to access the parent
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.