Showing results for 
Search instead for 
Did you mean: 
Not applicable

PowerBI + Configuration + Complex logic/calculations

Hi There,


I have a unusual ask here.


Can I pass the complex logic/calculations as an input to PowerBI reports. For ex. can I pass M query steps/DAX calculations as a parameter/input from a Excel file source which can be picked up by PowerBI reports when I refresh the data ?


I am able to pass static values from an Excel sheet into a dataset which I am able to consume in another dataset inside in the Edit Queries(M) tab. However I am unable to pass complex logic steps (Merge datasets, Group data etc.) which is then used in Advanced Editor for datasets.


Any inputs will be of great help..


Thanks in Advance,


Helpful resources

Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 376 members 4,130 guests
Please welcome our newest community members: