![]() |
#1
|
|||
|
|||
![]()
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? |
Tags |
power query, problem |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Power Query Formatted Text | gmaxey | Excel Programming | 4 | 11-18-2023 10:00 PM |
Excel power query help | ganesang | Excel Programming | 0 | 09-20-2021 01:50 AM |
Calculate age in power query as of a given date | Marcia | Excel | 1 | 11-12-2020 07:14 AM |
Do I need a power query for this one? | shabbaranks | Excel | 5 | 04-10-2019 03:29 AM |
Query and Power Query not working Excel 2016 | bl10 | Excel | 0 | 07-22-2016 06:25 PM |