Forum Discussion

jfishbac's avatar
jfishbac
Frequent Visitor
2 years ago
Solved

Excel Get Data from Power BI - Dynamic Filter Parameters?

Hi,   I'm just starting to explore the "Get Data from Power BI" feature that is now available in excel. I'm still working with my company to get this feature enabled. Once it's hopefully turned on,...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi jfishbac 

If you want to use the dynamic paramater to filter the report, after testing, it cannot change in excel, but you can consider to create a paramater in Power Query in Power BI, then when you want to change the paramater, you can change it in data source settings in Power BI Service. You can refetr to the following link.

Parameters - Power Query | Microsoft Learn

https://learn.microsoft.com/en-us/power-bi/connect-data/service-parameters#review-and-edit-parameters-in-power-bi-service

 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.