Forum Discussion

Siv_Abu's avatar
Siv_Abu
Frequent Visitor
3 years ago

Power BI Report Builder Query Parameter

Hi Please help

I have a Datasource :  A pbix file ( created using direct query Oracle SQL) 

I am creating a paginated report in Power BI Report Builder

I am using this Datasource as Power Dataset connection to my report builder.

I want to use Query parameters that pass it to the pbix file which is the my datasource (PBI Published Dataset which uses a direct query at its back to get data)

How do I send parameter filters in the Query Designer.

Am getting errors parameter not defined.

What are the things I have to check.

Is there a need to create a parameter at the PBIX Power Query Level also.

Please share link and a Oracle in Direct Query will it accept param in Query Designer Dax as a filter,

Please share the steps on how to do it any any sample Query Parameter passing to the pbix file Dax Syntax 

P

3 Replies

  • d_gosbell's avatar
    d_gosbell
    Super User
    3 years ago

    If you have a query like the following where you have typed or copied in a DAX query with a parameter reference like the @color parameter in the screenshot below


    Then you need to go into the Parameters tab in the Dataset properties and add a parameter with the same name (without the leading @ symbol) and provide a value to pass through.

    This can either be a hardcoded value or in the screenshot above I first created a report level parameter called pColor and this was then available in the "Parameter Value" drop down. This will allow my users to type in a value which will be passed into the query parameter.

    • d_gosbell's avatar
      d_gosbell
      Super User
      3 years ago
      Siv_Abu wrote:

      Hi am getting , Parameter not defined error d_gosbell 

      That means you have not provided values for all the parameters in your query using the Parameters tab in the dataset properties as per my previous post.