I have a requirement where I am filtering a power query with a power query parameter. Now I want to populate this parameter with a cell value from a sheet. Currently i am hardcoding it. Is there a way where I can update this parameter from VBA code...?
Why not make the cell a named range, then you can refer to that name in your Power Query?
let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source
If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE
Walking the tightrope between genius and eejit...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks