Power BI Report Builder Query Parameter

[Siv_Abu]

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 

[Siv_Abu]

Hi am getting , Parameter not defined error @d_gosbell 

[d_gosbell]

---

@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.

[d_gosbell]

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.