Forum Discussion
Pass Parameter from Power BI Service Report to Excel
I have a query in Excel which currently has a hard code parameter value like "City="NY". When Power Bi Service report runs, it reports data on "NY".
Is there a way to have this parameter value dynamically sent to Excel Query so I can use the same query for different city name?
Use Row level security to have data restrucition https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security
8 Replies
- arvindsingh802
Community Champion
Parameters can not be changed dynamically, intead used can update it based on there need https://learn.microsoft.com/en-us/power-bi/connect-data/service-parameters
If you want user to see different City data based on there need, would suggest to ingest data for all city and implement a slicer for city to filter based on need
I want to have Supplier1 to see only "LA" and Supplier2 to see only "NY" and Supplier3 to see only "IL"
- arvindsingh802
Use Row level security to have data restrucition https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security
v-kpoloju-msftCommunity Support
Hi MikeGanem2,
Thanks for reaching out to the Microsoft fabric community forum.
I would also take a moment to personally thanks arvindsingh802, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum.
I have gone through the details that you have shared based on that we have created some workarounds, as I have reproduced the scenario. Please go through the below scenario steps might resolve the issue.Yes, there is a way to dynamically pass parameters from a Power BI Service report to an Excel query. I have used it as sample data on my end and successfully implemented it. Therefore, please refer to the attached pbix file.
After setting up filtering in Power BI, go to Home, click Transform Data, and open Power Query. Click File, then Close & Load, and choose Load To an Excel Table. Save and refresh the Excel file whenever the Power BI report updates to get data for the selected city dynamically.
I hope this should resolve your issue, if you need any further assistance, feel free to reach out.
If this post helps, then please give us ‘Kudos’ and consider Accept it as a solution to help the other members find it more quickly.
Best Regards.
- v-kpoloju-msft
Hi MikeGanem2,
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
- v-kpoloju-msft
Hi MikeGanem2,
We have not yet received a response regarding our previous reply and would like to check if your issue has been resolved. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.
