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

July 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss 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
FabCon and SQLCon Barcelona 2026

FabCon & SQLCon – Barcelona 2026

Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.

60 days of Data Days Carousel

Data Days 2026

Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.

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.