PowerBi Service issue for Report

[Ram007]

There is an unique issue occuring on PowerBi service after data refresh.
For line chart the x-axis date value got auto formated and so shows some future date.
The only way to fix issue is to republish the report again. It is happening after every time data refresh schedule.
The screenshot of error also attached for more clerarity. It is happening after every time data refresh schedule.

[Ram007 · Accepted solution]

Thank you Everyone for your responses.

I got fix the issue by changing the date column datatype as date from string value. 

If there any date couln value are in string format in database then this below covnersion may fixed the issue arised by me:

CONVERT(datetime, [DateColumn] ,103)

Once again. Thank you community.

[v-alq-msft]

Hi, @Ram007 

I wonder if there is some hierarchical structure on the x-axis of the line chart visual. Are there some filters which have effects on the chart?

Best Regards

Allan

[GilbertQ]

Hi there

Can you make sure that you make sure the "Reset to Default" button is NOT enabled. Meaning that you do not have any user filters on the report?