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

[UsePowerBI]

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!

[v-eqin-msft · Accepted solution]

Hi @UsePowerBI ,

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.

[v-eqin-msft · Accepted solution]

Hi @UsePowerBI ,

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

[v-eqin-msft · Accepted solution]

Hi @UsePowerBI ,

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.

[StefanoGrimaldi]

try out this: https://www.excelguru.ca/blog/2018/05/30/creating-dynamic-parameters-in-power-query/