Using Measure for passing value to paginated report in PBI Desktop

[JaromG]

I have embedded paginated report in PBI desktop using the Paginated Visual. I am now trying to pass a value from a measure I have in the model which is simply:

Int Measure = 1

I have mapped Measure to the paginated report parameter and when I preview data I can see that meausres value properly passing into the data that will pass to the paginated report. However, I get an error when trying to use the measure as a value to pass. Is this a limitation in power bi? 

Int Measure returns an Integer. (Code updated to INT(2022) and still doesn't work. Screenshot below is an old code snippet of the measure. 

[farrukhali6177]

It seems like you've done a great job setting up the paginated report in Power BI Desktop and mapping the measure to a parameter. However, encountering an error when trying to use the measure as a value to pass can be frustrating. While Power BI is a robust tool, there might be some limitations or issues at play.

Firstly, ensure that the measure is returning a valid integer value, and that there are no data type conflicts. Additionally, check if the parameter in the paginated report is set up correctly to receive an integer value.

If you've verified these aspects and are still facing issues, it's a good idea to reach out to Power BI's support or community forums for more specific assistance. You're not alone in facing such challenges, and often the community can provide insights and solutions.

Remember, Power BI is a powerful tool, and sometimes issues arise due to minor details. Stay persistent, and with the right approach, you'll likely be able to overcome this hurdle and make your paginated report work seamlessly with the measure value.

[JaromG]

@amitchandak , 
In paginated report, I am not using the parameter anywhere. I am simply trying to get the paginated report to accept a measure value. 

Measure Data Type in PBI: Whole Number (Int)

Parameter data type in paginated report: Integer

Additional Details are simply the database details: 

Power BI when setting the binding between measure and paginated report shows the right value: 

Also, when testing in paginated report only (not embedded in PBI desktop) It runs fine passing an integer. 

[amitchandak]

@JaromG , Make sure the Report parameter has the same data type. Make sure the report parameter is used to query or filter properly.

CLick on more details and share error