Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi Community
I use PowerQuery to filter the datasource directly on that level for my visuals.
This works great, but I would like to pass this parameter (string) in the URL.
The parameter I have created is called "CostCenter".
Then I use "CostCenter" in the table to already filter only the rows that I require.
It filters all the data in the report, which is great.
I use Power-BI Embedded and the Direct Query Mode.
Can you help me to pass this value in the URL?
Many thanks!
Solved! Go to Solution.
Hi @gabriel-mendes ,
From my knowledge, I am afraid that your requirement is unattainable. According to the screenshot you provided, your parameter was created in Power Query, and in general, a parameter in Power Query can only work in Power Query, it can't even be passed to Power BI Desktop, much less to Power BI Embedded.
You mentioned that your connection mode is Direct Query, and that connection mode does have a way to pass the parameters you create in Power Query for use in Power BI Desktop, but that method has numerous limitations. I'm not sure how your parameter was created, so I'm not sure if it works.
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
If this method works, you can try to publish the parameter in your report as mentioned in the documentation, and then embed the report, but the final embedding result should not be what you want, because this method requires you to go back to Power BI Service and modify the parameter manually before you can display the data corresponding to the other parameter.
Currently the only parameters that can be applied in the report URL should be those mentioned in the documentation like the one below. Can you check if this is an alternative?
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @gabriel-mendes ,
From my knowledge, I am afraid that your requirement is unattainable. According to the screenshot you provided, your parameter was created in Power Query, and in general, a parameter in Power Query can only work in Power Query, it can't even be passed to Power BI Desktop, much less to Power BI Embedded.
You mentioned that your connection mode is Direct Query, and that connection mode does have a way to pass the parameters you create in Power Query for use in Power BI Desktop, but that method has numerous limitations. I'm not sure how your parameter was created, so I'm not sure if it works.
Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn
If this method works, you can try to publish the parameter in your report as mentioned in the documentation, and then embed the report, but the final embedding result should not be what you want, because this method requires you to go back to Power BI Service and modify the parameter manually before you can display the data corresponding to the other parameter.
Currently the only parameters that can be applied in the report URL should be those mentioned in the documentation like the one below. Can you check if this is an alternative?
Filter a report using query string parameters in the URL - Power BI | Microsoft Learn
Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
We need more information, like:
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
12 | |
8 | |
8 | |
7 |
User | Count |
---|---|
15 | |
13 | |
9 | |
7 | |
6 |