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

A new Data Days event is coming soon! This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. Don't miss out.

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
May Power BI Update Carousel

Power BI Monthly Update - May 2026

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

Fabric SQL PBI Data Days

Data Days 2026 coming soon!

Sign up to receive a private message when registration opens and key events begin.

New to Fabric survey Carousel

New to Fabric Survey

If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.

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.

Top Solution Authors