Forum Discussion

Ram007's avatar
Ram007
Frequent Visitor
6 years ago
Solved

PowerBi Service issue for Report

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 republ...
Need Help
  • Ram007's avatar
    Ram007
    6 years ago

    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.

Ram007's avatar
Ram007
Frequent Visitor
6 years ago

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.