How to pass list of values parameter into a PowerQuery to import data

[Anonymous]

Hi All,

I have a parameter created in Deskotp witht the name "FYear" which is a list of values as below 

FY 2018

FY 2019

FY 2020

FY 2021

.

FY 2040

I want to pass this list onto a Power Query which import data from SQL server analysis service.

Could you please help me with the Pquery on how to achieve this?

Thanks in Advance:

Nishanth

[v-yuta-msft]

@Anonymous ,

Have you solved your issue by now? If you have, could you please help mark the correct answer to finish the thread? Your contribution will be much appreciated.

Regards,

Jimmy Tao

[Lidou_Cand]

Hello,

Is it possible to have several values ​​to feed a parameter in Power query?

[v-yuta-msft · Accepted solution]

@Anonymous ,

I would suggest you to refer to blogs below:

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

https://powerbi.microsoft.com/de-de/blog/deep-dive-into-query-parameters-and-power-bi-templates/

Community Support Team _ Jimmy Tao

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