Forum Discussion
Year selection in Query
Hi de_ppd
in query editor, you can create query parameter and configure a list of values(parameters you need) previously. For mode details, I would suggest you refer to doc below:
https://docs.microsoft.com/en-us/power-query/power-query-query-parameters
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/
Hello Greg_Deckler,
my target is that I do not need to load all available years in my query. I want to load only the time.calendar years 2019 & 2020. Because the data is to much and I get timeouterrors for my queries. Because now I load all years and filter after that in PowerBI Dekstop the 2 years. But it is to much for refresh without any timeouterrors.
Best regards
Hi de_ppd
in query editor, you can create query parameter and configure a list of values(parameters you need) previously. For mode details, I would suggest you refer to doc below:
https://docs.microsoft.com/en-us/power-query/power-query-query-parameters
https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/
https://www.biinsight.com/power-bi-desktop-query-parameters-part-1/