Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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 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.
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.