Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have query (query 1) that performs a lot of steps to correct the dataset, I load it to excel and then I loaded it back to PQ, Now I use this query (query_1) to perform other corrections, which give me some performance while I do the subsequent query steps.
But in the future I will change to query 1 and discard query_1...
The thing is, I would like to use a Parameter to rapidily change the reference.
Without using a parameter:
let
Source = #"query 1"
in
Source
I want to use the parameter value in the blue highlighted text.
Solved! Go to Solution.
Hi, @gadao
You can try the following solution:
1. create a custom fuction SwitchQuery:
(query as table)=>
let
source = query
in source
2. Invoked fuction:
let
Source = SwitchQuery(Query2)
in
Source
2. for the Main table:
let
Source = #"Invoked Function"
in
Source
You only need to change the query of the invoked function to change the query of the main table at any time.
Result:
Please refer to the attachment below for details.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @gadao
You can try the following solution:
1. create a custom fuction SwitchQuery:
(query as table)=>
let
source = query
in source
2. Invoked fuction:
let
Source = SwitchQuery(Query2)
in
Source
2. for the Main table:
let
Source = #"Invoked Function"
in
Source
You only need to change the query of the invoked function to change the query of the main table at any time.
Result:
Please refer to the attachment below for details.
Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I think isn't that...
Let me put this way, let's say I have two queries in PQE and then i created a blank query.
If I write: let Source = #"Query1" in Source | it will show the data from Query1 if I change the code for Query2 it will show the data in Query 2,
I want a switcher to make this change using a parameter or any other thing.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
53 | |
21 | |
12 | |
12 |