Forum Discussion

heilamckinley's avatar
heilamckinley
Frequent Visitor
1 year ago
Solved

Populating parameters on report before query executes

I have a Power BI report using Direct Query to a SQL Server database.  Users will access this report via an app.  On the report is a table with a number of columns.  I want the user to open the repor...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi heilamckinley  ,

    Power BI doesn’t currently allow users to type in parameter values directly in the report view the way you might in traditional tools (like SSRS). Dynamic M query parameters require the values to come from a field or slicer in the data model.

    Dynamic M query parameters are supported only in Power BI Service  when using DirectQuery mode. They are not supported in Power BI Report Server.

    So if you’re publishing to an app that’s based on the Power BI Service (workspace - > app), then yes, you can use dynamic M parameters there. But if your environment uses Power BI Report Server, this functionality won’t work.


    I hope this information helps. Please do let us know if you have any further queries.
    Thank you

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi heilamckinley 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.


Thank you.