Forum Discussion
New to Power BI Embedded - Change parameter acording to the session
Hi! I developed a dashboard that I plan to embed in my portal. I have a question: since the dashboard is designed to display data for a specific city, I created a parameter in Power Query to store the current city's ID (as it relates to the database).
I want to dynamically update this parameter during a session, so that depending on the page where the dashboard is embedded, it displays data for a different city. Is this possible with Power BI Embedded? If yes, how can I achieve it?
I’d appreciate any help, as I’m new to Power BI Embedded.
Hi, vanderbright
You may consider the following two solutions:
1.Firstly, you can use dynamic M query parameters, which allow report viewers to set the values of M query parameters through filters or slicers. This approach can enhance query performance and enable users to select different city IDs within the report.
For further details, please refer to:
Solved: Passing Parameters Dynamically in Power BI Embedde... - Microsoft Fabric Community
Parameters - Power Query | Microsoft Learn
2.Secondly, if your data model supports Row-Level Security (RLS), you can set different access permissions for various users. This way, when users view the report, they will only see data relevant to them. This method is suitable for scenarios where data needs to be dynamically adjusted based on user identity.
For further details, please refer to:
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi, vanderbright
You may consider the following two solutions:
1.Firstly, you can use dynamic M query parameters, which allow report viewers to set the values of M query parameters through filters or slicers. This approach can enhance query performance and enable users to select different city IDs within the report.
For further details, please refer to:
Solved: Passing Parameters Dynamically in Power BI Embedde... - Microsoft Fabric Community
Parameters - Power Query | Microsoft Learn
2.Secondly, if your data model supports Row-Level Security (RLS), you can set different access permissions for various users. This way, when users view the report, they will only see data relevant to them. This method is suitable for scenarios where data needs to be dynamically adjusted based on user identity.
For further details, please refer to:
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.