Doing a PowerQuery with a Shareopint Library

[martirl3]

I come over from  the PowerApps side.  It seems PowerQuery has its roots here.  Well, I was enjoying some new functionality with CDS Dataflow, and I was happily pushing some Sharepoint data into CDS using PowerQuery.  I came to the realization that none of my Sharepoint Lists were appearing as datasources.  I even tried to hack the name a bit in the statement to see if I could steal access, and no luck.  I would think that the fields in a Library would be equally retrieveable as those fields from a List.  I'm not finding this to be true.  So, is this possible?  

I did find another post asking this, but it was 2 years old, and no update.  They also mentioned adding an idea for this issue.  I looked there with no luck either.  

By the way, I dont just want metadata, I need all of the column data.  There is a way to get metadata, but that is not useful for my case.

I posted this over here too.

https://powerusers.microsoft.com/t5/Common-Data-Service-for-Apps/Getting-Sharepoint-Library-data-int...

[Mariusz]

Hi @martirl3 

To get a list of your lists you can just use the below, it will return everything that you have access to.

What are you trying to do? 

let
  Source = SharePoint.Tables("https://company.com/sites/Engineering/")
in
  Source 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[martirl3]

@Mariusz ,

THat method only shows lists, not libraries.  

I need the data fields from a library.

[martirl3]

@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.

[Mariusz]

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 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[martirl3]

@Mariusz ,

That works, but all you get is the file metadata.  Table data is not found.  File metadata is pretty much worthless.

[Mariusz]

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-files

https://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