Date Format not working when refreshed

[jmikel]

I have a report with the following:

1. Date source pulls field in the following format 23/5/2025 (DD/MM/YYYY) 

2. I use the following DAX to change data type to a date and have it recognized as the proper format: =table.transformcolumntypes(#Changed Type With Locale", {{"Valid to Date", type date}}, "en-GB")

3. Data source is changes 23/5/2025 (DD/MM/YYYY) to 5/23/2025 (MM/DD/YYYY).

4. Publish report to service and date format is still correct.

5. Refresh service report and date reads 23/5/2025 as (MM/DD/YYYY) and therefore returning an error because there is not a 23rd month. 

Why does my DAX suddenly stop working when I refresh the report in the web server report?

[v-sathmakuri · Accepted solution]

Hi @jmikel ,

Thank you for reaching out to Microsoft Fabric Community.

Instead of using Dax query you can also format date using power bi desktop format option.

• Select the column, navigate to Column Tools, change Format to MM/dd/yyyy. I have formatted the date column following this process even the refresh is not throwing any error.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks & Regards,

Rekha,

CustomerSupportTeam.

[jmikel]

When I try to do this, I get a pop up saying: "Error We can't automatically convert the column to date type."

[v-sathmakuri]

Hi @jmikel ,

As we haven't heard back from you, we are closing this thread. If you have any further issues, please start a new thread in the community forum, and we will be ready to assist you. Thank you for being part of the Microsoft Fabric Community.

Thank you!!

[v-sathmakuri]

Hi @jmikel ,

Could you please provide me the sample data, so that i can use the same data and repro the issue.

Thank you!!

[jmikel]

Still no solution

[v-sathmakuri]

Hi @jmikel ,

I hope this information proves helpful. Feel free to reach out if you have any further questions or would like to discuss this in more detail. If responses provided answers your question, please accept it as a solution so other community members with similar problems can find a solution faster.

Thank you!!

[v-sathmakuri]

Hi @jmikel ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If the responses has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-sathmakuri]

Hi @jmikel ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[HarishKM · Accepted solution]

@jmikel  Hey,
Kindly have a look to this post -Solved: Date data/datetype changes on refresh in PowerBI s... - Microsoft Fabric Community
he also the same issue.

Thanks

Harish

[Cookistador]

Hello @jmikel 

Before your conversation in local, in whic format are your date ?

In the "Changed Type" step in Power Query, in which format is converted ?

Before to convert it into date, can you be sure that your Valid to date is in text type ? (and check that it is not converted into data in a previous step)

[v-sathmakuri · Accepted solution]

Hi @jmikel ,

Thank you for reaching out to Microsoft Fabric Community.

Instead of using Dax query you can also format date using power bi desktop format option.

• Select the column, navigate to Column Tools, change Format to MM/dd/yyyy. I have formatted the date column following this process even the refresh is not throwing any error.

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thanks & Regards,

Rekha,

CustomerSupportTeam.