Import sql database tables in a dynamic way

[dimmark995]

Hi Team,

I have the following problem. Lets say i have stored my tables in a SQL server with the following names (Sales_April2024, Sales_May2024, Expenses_April2024, Expenses_May2024 etc. My goal it to allow the end user select from two slicers the Month and Year. This will result in a refresh of tables (and visuals as a result) from the sql database based on month and year. The steps i took were the following                                                                        1) Created two parameters for Month and Year                                                                                                                                        2) Created the following queries for fetching the tables based on the parameter values

  When i change the parameter from April to May from "Edit Parameters" it seems to work but i want an automated solution

Thanks in advance                                                                                                                     

[v-xinruzhu-msft]

Hi @dimmark995 

You can consider to use dynamic paramaters, it allows user to change the patamater value by selecting the value in slicers, but it is only support in direct query mode, you can refer to the following link about it.

Dynamic M query parameters in Power BI Desktop - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

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