Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Solved! Go to 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.
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
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
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.
try out this: https://www.excelguru.ca/blog/2018/05/30/creating-dynamic-parameters-in-power-query/
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.