I have figured out dataflow to get SQL and Sharepoint tables into CDS quite readily now. However, a challenge exists with Sharepoint Libraries. While all I am needing are the list parameters of the library, I have not been able to find a way to get that in. I'm sure there is a way, its just getting the syntax right.
I have done this, which should work, in theory, if libraries are supported:
let
Source = SharePoint.Tables("https://company.com/sites/Engineering/"),
Navigation = Source{[Name = "Drawing_Vault"]}[Properties]
in
Navigation
Hi @martinav,
I'm not a SharePoint expert, but have you also tried to SharePoint community (https://techcommunity.microsoft.com/t5/sharepoint/ct-p/SharePoint) and Power BI community for PowerQuery (https://community.powerbi.com/t5/Power-Query/bd-p/power-bi-services) since this doesn't seem to be directly related with CDS. These are channels that can provide additional support.
Good luck!
User | Count |
---|---|
19 | |
9 | |
8 | |
5 | |
5 |
User | Count |
---|---|
32 | |
29 | |
18 | |
18 | |
6 |