Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Date field converted as string when dataset is consumed in paginated report (report builder)

In paginated report the field which is of type date is shown as string and hence the range slicer is not working correctly. Any way to convert the type of the field in paginated report back to date and use them in range slicer?

 

I have followed the method described here :- https://blog.coeo.com/using-date-pickers-in-power-bi-report-builder.. It doesn't work either may be because the paginated report field is string though its of type date in the PBI dataset , which is the source of the paginated report.

 

When I check in the field I get the below error as well :-

 

Jerinfonterra_0-1685612108468.png

 

Status: Investigating
Comments
Anonymous
Not applicable

Hi @Jerinfonterra 

There is no way to change the field types on Service, you need to go back to the report builder and rework your template and upload it here to Service .

 

Best Regards,
Community Support Team _ Ailsa Tao

 

 

Jerinfonterra
Frequent Visitor

@Anonymous  thanks for the response. Please note that Im not trying to do any thing on the service. Im trying to build the report using report builder consuming the Pbi dataset. The field that is of date format in the PBI data set is recognized as string and is giving the below error 

 

Jerinfonterra_0-1685697366807.png

 

JiriRak
Frequent Visitor

Is there a solution to this? I have got the same issue: I have got a data set from PBI connected in the report builder and field that is Date/Time is received as Text.

This widget could not be displayed.