Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old Yesterday, 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
Reply

Tags
power query, problem

Thread Tools
Display Modes


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 03:12 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