Importing multiple named ranges from Excel and transforming

[Anonymous]

Hi,

Is it possible to establish a function in Power Query to import a list of named ranges from an Excel file based on a parameter with list and apply the same transformation across each to create individual tables?

I'm currently importing each manually but I'm sure there is a better way but I can't seem to get the parameter in the Source right as it is failing for me.

Cheers,

Andrew

[GilbertQ · Accepted solution]

Hi @Anonymous

Yes this can be done by creating a function.

The one question that I have to ask is with each named range, are the data structure (Columns) the same between each named range?

If that is correct you can do this.

There is a video by Guy In a Cube explaining this: Dynamic Power BI reports using Parameters

If you get stuck please let me know.