PBI Automatic Date Change - Analysis Services

[Anonymous]

I have a PBI report that connects to the Analysis Services Model to retrieve data

A date column within the model is within a specific format but gets automatically converted when being imported. The format of DD/MM/YYYY but it gets changed to M/DD/YYYY Non-24 hr time

I have tried some posts on this forum to change the setting to Local using PBI desktop but since its not using direct query it cant make this change on the incoming model data.

Is this a limitation of sorts?

[Anand24]

@Anonymous,

Basically, you need to assure 2 things:

1. From Power Query Editor, Locale is set to English(India) so that it will give dd-mm-yyyy format

2. From report view, date field's Format is properly set to dd-mm-yyyy

Check the below thread as well. Should be helpful in your scenario.

https://community.powerbi.com/t5/Desktop/How-delete-name-of-the-day/m-p/1271638#M557799

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

[V-lianl-msft]

Hi @Anonymous ,

If you have an English locale that is not US English (eg UK or Australian English), you may find that date columns appear to be formatted correctly as dd/mm/yyyy in the SSDT,but when you get to power bi you see the dates formatted in the US mm/dd/yyyy format.

Try to modify the data format, as @Anand24 and @amitchandak  said.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[FarhanAhmed]

Is this a Tablular Model or Multidimensional ?

Have you checked your date formatting in Analysis Services? Seems like it is coming from there

[Anand24]

@Anonymous,

Try changing the date format after pulling your data to Power BI. This might resolve your issue.

Just an FYI that Direct Query does have limitations on date columns. The time intelligence capabilities are not available with Direct Query.

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query  !!!

[amitchandak]

@Anonymous , for UK format you need have setting at windows level -https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/599712

Other format you can manage inside data format