Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

PBI Automatic Date Change - Analysis Services

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?

 

 

Need Help

5 Replies

  • Anand24's avatar
    Anand24
    Super User
    6 years ago

    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  !!!

  • FarhanAhmed's avatar
    FarhanAhmed
    Community Champion
    6 years ago

    Is this a Tablular Model or Multidimensional ?

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

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

    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.

  • Anand24's avatar
    Anand24
    Super User
    6 years ago

    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 !!!