Forum Discussion
Doing a PowerQuery with a Shareopint Library
Mariusz ,
There is a Sharepoint Folder option. That shows the libraries, but you only get file metadata. No list/column data.
I'm not savvy with all of the interfaces into powershell, but I'm using the interface from PowerApps, the Dataflow section. I'm not sure if its different in other places.
Hi martirl3
Sorry, I'm probably not much help as I have no idea about Power Apps, but I think that Connectors should be the same across the platform ( Power Apps/Bi )
You can check what SharePoint.Contents do if you haven't yet?
https://docs.microsoft.com/en-us/powerquery-m/sharepoint-contents
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
Mariusz ,
That works, but all you get is the file metadata. Table data is not found. File metadata is pretty much worthless.
Hi martirl3
There are only 3 SharePoint functions that I know of, it looks like you tried all of them.
https://docs.microsoft.com/en-us/powerquery-m/sharepoint-contents
https://docs.microsoft.com/en-us/powerquery-m/sharepoint-fileshttps://docs.microsoft.com/en-us/powerquery-m/sharepoint-tables
I hope you will the solution you looking for, but I'm out of ammunition 😀
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn