Forum Discussion
Import sql database tables in a dynamic way
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...
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.