Forum Discussion

timazarj's avatar
timazarj
Helper II
1 year ago
Solved

local Processing Error Paginated Report

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: - FromLinesExpir...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    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

Kedar_Pande's avatar
Kedar_Pande
Super User
1 year ago

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's avatar
timazarj
Helper II
1 year ago

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's avatar
    Anonymous
    Not applicable
    1 year ago

    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