Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old Today, 08:52 AM
ervidel ervidel is offline Power Query Help Windows 11 Power Query Help Office 2021
Novice
Power Query Help
 
Join Date: Jun 2025
Posts: 1
ervidel is on a distinguished road
Default 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?
Reply With Quote
 

Tags
power query, problem



Similar Threads
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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:32 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft