Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Dynamic Excel table

Hello All,

 

I´m new in this forum, so firstly thank you for sharing all your thoughts in here.

 

My question is about linking PowerBI to an Excel tool that gives you a result based on the end user input. Basically, the end user will choose inputs from a dropdown list (in PowerBi), the this parameter goes to the excel tool and fianlly the user will see the result in the dashboard coming from Excel

 

Thank you very much.

Beatriz

 

 

2 REPLIES 2
shill1000
Helper IV
Helper IV

I suspect this can't be done exactly how you describe. Parameters can be entered into Power Query and used to drive queries, but that's only within the query editor. Unless you allow the end user to access the PBIX itself, they won't be able to edit the query. Any filters etc. within the published report will only affect the data already delivered by the query, not cause it to be re-queried.

 

Assuming you don't want users accessing the raw data itself, you could set up your query(s) pointing to the base data and a separate query pointing to a shared 'parameter' file that they can amend and save. By merging queries you can use the parameter query to drive the output of the data query. 

 

An alternative which isn't really what you look like you want could be to create various versions of your report with the difference being the parameters the users could use. But this would be impractical unless you are dealing with a minimal number of parameters or they have a small range of values.

 

Alternatively, you could set up a variety of bookmarks with preset combinations of filters that would equate to the same thing. Though beyond a handful of bookmarks this could too be impractical if you are trying to offer a large range of parameters and/or the parameters have a large number of available values.

 

But no, you can't use the Power BI service/published reports to send parameters to the PQ queries in your PBIX dynamically.

artemus
Microsoft Employee
Microsoft Employee

I'm not clear what your trying to do. What do you mean by "an Excel tool"?

 

In general, Power Bi can import data from Excel, but you can't directly use any of the formula logic you have in cells.

 

If you mean to generate Excel on the fly for users, you would be better off simply generating a csv file instead.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.