Forum Discussion
Dinamic M query Parameters
Hi, I need help witj aplying M query parameters and I cant solve the problem. I want to conect to a Oracle DB in direct query mode, using dinamic parameters with slicers in order to filter de SQL...
Hello - no need to use parameters in M Code for this. Make your connection, then just add the filters you want the users to filter by to your filter pane in Power BI - they will select what they want and your visual will render.
Hello, this is just a demo. The final SQL nativ query will contain subselects with, for example, a range of dates. Because of that, I need to aplly dinamic parameters to the sql query, in order to reduce que time of compilation.