local Processing Error Paginated Report

[timazarj]

Hi,

I am developing a paginated report using a power bi semantic data model as a source and defining a date range (expiration date) parameter. The properties of the parameters are:
- FromLinesExpirationDate: Data Type: Date/Time    Default Value: No default value  Available Value: None
- ToLinesExpirationDate: Data Type: Date/Time    Default Value: Format((Parameters!ToLinesExpirationDate.Value),"yyyy-MM-dd")   Available Value: None

And on the dataset properties:
-FromLinesExpirationDate: =Format((Parameters!FromLinesExpirationDate.Value),"yyyy-MM-dd")

-ToLinesExpirationDate:=Format((Parameters!ToLinesExpirationDate.Value),"yyyy-MM-dd")

But when I tried to run, I received this error:
"An error occurred during local report processing."

Details: "Exception of type 'Microsoft.ReportingServices.ReportProcessing.ReportProcessingException' was thrown.
----------------------------
An error occurred during local report processing."

Please advise me.

[Kedar_Pande]

Fix Parameters:

FromLinesExpirationDate: No default value.
ToLinesExpirationDate: Set to =Today() or no default value.

Dataset Properties:

Remove Format function, use:

FromLinesExpirationDate: =Parameters!FromLinesExpirationDate.Value
ToLinesExpirationDate: =Parameters!ToLinesExpirationDate.Value

If this helped, a Kudos 👍 or Solution mark would be great!🎉
Cheers,
Kedar Pande
Connect on LinkedIn

[timazarj]

Thank you, but it's not working:

 I tried both Today() and no default value for  ToLinesExpirationDate, but received this error
Query (1, 88) DAX comparison operations do not support comparing values of type Date with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.
----------------------------
Query execution failed for dataset 'ToLinesExpirationDate'.
----------------------------
An error has occurred during report processing.
----------------------------
An error occurred during local report processing.

[Anonymous · Accepted solution]

Hi @timazarj ,
According to your description, the default value of ToLinesExpirationDate is set to Format((Parameters!ToLinesExpirationDate.Value), “yyyy-MM-dd”), which seems to reference itself. This may cause problems. Try removing the default value expression for ToLinesExpirationDate and then run the report. Also the default value of Format will be is of type string, which doesn't match the datetime type you are quoting. If the parameters are not required, make sure your dataset query can handle null values. If they are required, make sure you provide a valid date before running the report.

Best regards,
Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly