I am managing an estate of around 70+ paginated reports. All reports were working successfully up until yesterday.
Originally noticed as reports were failing to load with the following error:
Unable to render paginated report
Query execution failed for dataset "Summary".
by cancelling the report load and changing the date to anything less than 12/12/2022 e.g. a date which can be a month or a day I noticed that it was failing due to the date being passed to the Power BI dataset in the wrong format
Paginated report builder itself knows the format is correctly 3rd May but Power BI seems to think this is the 5 March. Browser Date format is UK (tried in Edge and Chrome)
In Report Builder I have specified the format for my parameter:
and I have tried both with and without Language set in the report itself:
As mentioned, this was working as expected until today. Some reports still work fine, others are failing.
The date format in the Power BI dataset/model is dd/mm/yyyy too.
Power BI version:
We have tried deleting and re-publishing the dataset with no difference.
To ensure the correct data type is passed into the DAX query, replace the parameter value with the following expression, where<your_parameter_name>is the name of your parameter. The Format function returns a string formatted to a given condition, in this case it will be a date string in the format of dd-MM-yyyy.