Power Query Help
Hello
I'm moving a couple of files to SharePoint and one of them is running a power query (PQ) on the other file. I know have to change the Source location and it is with that where I have problems.
[Local file as Source]
let
Quelle = Folder.Files("C:\Users\USER\OneDrive - COMPANY, Inc\SBU PjM Team - Europe - 3.3 Workload Estimation & Resource Forecast\Template"),
Navigation1 = Quelle{0}[Content]
in
Navigation1
[Remote file as Source]
let
Quelle = SharePoint.Files("https://COMPANY.sharepoint.com/teams/PjM-Europe", [ApiVersion = 15]),
Filtered = Table.SelectRows(Quelle, each Text.Contains([Folder Path], "Shared Documents/03. Projects/3.3 Workload Estimation & Resource Forecast/Template"))
in
Filtered
This seams to work at first, but down the line like with the "transform sample file" it doesn't.
what am I doing wrong and how do I fix it please?
|