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

July 28 - August 9 | Final Round of the Power BI Dataviz World Championships. This is your chance. 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
Fabric Community Sticker Design Challenge Barcelona Carousel

Fabric Community Sticker Challenge - Barcelona 2026

If you love stickers, then you will definitely want to check out our community sticker challenge, Barcelona edition!

July Power BI Update Carousel

Power BI Monthly Update - July 2026

Check out the July 2026 Power BI update to learn about new features.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.