Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hello, I post here because I try to send a parameter to a power query in a published power bi. This parameter is an ID in order to select a file inside a folder with a lot of files. I tried with an url, but I only find how to send a visual filter, not sending an argument. Does someone have an idea?
Thanks.
Solved! Go to Solution.
Hi, @Quentin36
According to your description, you use a parameter in your power Query Editor , and you want to modify the parameter in it .
If you want to modify the parameters in Power Query in Power BI Service, then you need to find "Parameters" in "Setting" of Dataset, and then modify the corresponding parameters. We cannot change the value of parameter through URL.
And if your paramter is greyed out , you can see this limitation:
And for more information, you can also refer to :
Edit parameter settings in the Power BI service - Power BI | Microsoft Learn
Power BI parameters - Updating in the Power BI Service or with APIs - YouTube
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Hi, @Quentin36
According to your description, you use a parameter in your power Query Editor , and you want to modify the parameter in it .
If you want to modify the parameters in Power Query in Power BI Service, then you need to find "Parameters" in "Setting" of Dataset, and then modify the corresponding parameters. We cannot change the value of parameter through URL.
And if your paramter is greyed out , you can see this limitation:
And for more information, you can also refer to :
Edit parameter settings in the Power BI service - Power BI | Microsoft Learn
Power BI parameters - Updating in the Power BI Service or with APIs - YouTube
Thank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
Thanks a lot, the solution was in the video with modification of the parameter thanks to a Powershell Script.
Best Regards
| User | Count |
|---|---|
| 24 | |
| 19 | |
| 11 | |
| 10 | |
| 7 |
| User | Count |
|---|---|
| 42 | |
| 36 | |
| 20 | |
| 18 | |
| 16 |