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, I'm wondering if I can filter the amount of data called into the Excel file based on a parameter that I set in my Excel file.

 

For example, let's say I have a bunch of data for many "Project IDs" that is consolidated in Power BI. I want to query some of that consolidated data from Power BI into another Excel report template. Let's say in this example, I want to generate a report for Project ABC.

 

When I set up my connection to Power BI, I want to pull in a table of data (let's say Sales by Date), but I'd like to only show results for Project ABC.

 

Then, let's say I want to create a new report, but this time for Project XYZ. I'd like to change my excel report parameter to XYZ, refresh my Power BI connection, and then show only results for Project XYZ.

 

Is this possible?

 

Thanks!

1 Reply