Forum Discussion
Report Builder Problem using Power BI Data Set as Source
Hi juncco888 ,
You need to convert your date column to date format.
Show some sample data and we might be able to help you convert it with formula or format feature.
Or you can check the documents below about how to convert format in power bi.
https://docs.microsoft.com/en-us/power-bi/desktop-custom-format-strings
https://community.powerbi.com/t5/Desktop/how-to-change-text-to-date/td-p/16067
If I have misunderstood your meaning, please provide more details about it.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Polly,
Thanks. However, the date field is already a date field in the power Bi report dataset and functions correctly as a date. The issue is that Report Builder (paginated reports) changes the type from date to string. I know a way to convert it using a calculated field but that should not be necessary and adds an additional field to my data set. I have a support ticket opened and will update here after that call.
Thank you again, I appreciate your assitance
Kyle
Hello,
Did you ever end up finding a solution to this? I've been unable to change the format from text when going to apply any filters to date or numerical values. They're consistently being imported as strings (text)
