Paginated Report Builder Dates Passing to Power BI Dataset in Incorrect Format

[cjbowman69]

Hi all,

I previously posted this in early May (https://community.powerbi.com/t5/Issues/Paginated-Report-Builder-Dates-Passing-to-Power-BI-Dataset-i... and the issue resolved itself over the weekend with no intervention. It has since returned with what appears to coincide with the datamarts preview release. 

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. 

Please advise.

[v-xiaoyan-msft]

Hi @cjbowman69 ,

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.

=Format((Parameters!<your_parameter_name>.Value), "dd-MM-yyyy")

For more you may refer Using Date Pickers in Power BI Report Builder 

Best Regards,
Community Support Team _ Caitlyn

[cjbowman69]

Hi Caitlyn,

Thanks for getting back to us. Unfortunately this has not resolved the problem. 

Happy to set up a call to run through it if that is easier.

Kind regards,

Christian

[cjbowman69]

Hi Caitlyn,

Any chance for an update on this? 

Cheers,

Christian

[v-xiaoyan-msft]

Hi @cjbowman69 ,

Based on the above information, if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

Best Regards,
Community Support Team _ Caitlyn