Forum Discussion
Parameterized report with native SQL queries
Hi webportal
This can be possible with the help of Dynamic M query parameters in Power BI Desktop. This feature can let you bind a column field to a query parameter which is used in the M query. The column field can be used in a slicer in the report for report users to switch different values. The M code will then be modified by the slicer selections to send different queries to the data source.
As the dynamic queries will be affected by the slicer selections, the underlying table must be in DirectQuery mode. There are some considerations and limitations you need to be aware of, please read Considerations and limitations section from the linked documentation above.
Hope this would be helpful.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!
Thanks for your help.
I was thinking about having the Power BI user defining the cutoff date (not Power Query parameters).
Hi webportal
This can be possible with the help of Dynamic M query parameters in Power BI Desktop. This feature can let you bind a column field to a query parameter which is used in the M query. The column field can be used in a slicer in the report for report users to switch different values. The M code will then be modified by the slicer selections to send different queries to the data source.
As the dynamic queries will be affected by the slicer selections, the underlying table must be in DirectQuery mode. There are some considerations and limitations you need to be aware of, please read Considerations and limitations section from the linked documentation above.
Hope this would be helpful.
Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!