Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

How can I specify a parameter whose values will be taken from a spreadsheet?

Hello

I want to maintain a spreadsheet with with some values which I want to feed into the Power Query code in Excel.

E.g. a date that I can change in the spreadsheet and it will be cascaded to the queries etc.

How can I do that?

Thanks!

StefanoGrimaldi
Resident Rockstar
4 years ago
try out this: https://www.excelguru.ca/blog/2018/05/30/creating-dynamic-parameters-in-power-query/
Anonymous
Not applicable
4 years ago
Hi Anonymous ,

Could you tell me if my post helps you? If it is, kindly Accept it as the solution to make the thread closed. More people will benefit from it.

Best Regards,
Eyelyn Qin
Anonymous
Not applicable
4 years ago
Hi Anonymous ,

If you want to parameterize your data source

you could kindly refer to:

Dynamic M query parameters in Power BI Desktop (preview) - Power BI | Microsoft Docs

Parameterize your data source!

Change the Source of Power BI Datasets Dynamically Using Power Query Parameters - RADACAD

Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.