Import sql database tables in a dynamic way

Question

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&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1) Created two parameters for Month and Year&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2) Created the following queries for fetching the tables based on the parameter values&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; When i change the parameter from April to May from "Edit Parameters" it seems to work but i want an automated solution&nbsp;Thanks in advance&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;

anonymous · Answer

Hi&nbsp;dimmark995&nbsp;
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
&nbsp;
&nbsp;
Best Regards!
Yolo Zhu
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

Forum Discussion

Import sql database tables in a dynamic way

1 Reply

Related content

Database connectivity.

Importing dynamic named worksheets

Dynamic Date Parameter for Import Queries

Dynamic Filter

Mirrored Snowflake Database Storage