Reply
Frequent Visitor
Posts: 3
Registered: ‎04-19-2017

How to change date format from MM/DD/YYYY to DD/MM/YYYY in Power BI Service?

Hi,

 

I was wondering if there were any Zuora users out there who also use Power BI Service (not desktop)?

 

We are trying to change the date format in Power BI as it currently is set to a US format (MM/DD/YYYY).

 

As the data is ingested into Zuora is currently set to DD/MM/YYYY as we are in Australia, not all of the data is coming through.

 

Hoping for a mircale fix!

 

Thanks in advance,

 

Geoffrey

Super Contributor
Posts: 2,712
Registered: ‎06-25-2015

Re: How to change date format from MM/DD/YYYY to DD/MM/YYYY in Power BI Service?

@seeneenc Unfortunately there is no way to change the datatype or format in the Service. There is an effort to add those online services as data sources in the Desktop, but Zuora is currently not in there yet. Wish I had a better answer Smiley Sad

Frequent Visitor
Posts: 3
Registered: ‎04-19-2017

Re: How to change date format from MM/DD/YYYY to DD/MM/YYYY in Power BI Service?

Thanks for the heads up @Eno1978! Much appreciated Smiley Happy

 

Hoping there is a fix/solution soon.

Moderator
Posts: 1,937
Registered: ‎03-06-2016

Re: How to change date format from MM/DD/YYYY to DD/MM/YYYY in Power BI Service?

@seeneenc

 

As @Eno1978 said, currently it's not supported to change the date format on Power BI Service. You may submit a feature request on idea. To workaround this, you can create an extra text column for expected date format.

 

Regards,

Frequent Visitor
Posts: 3
Registered: ‎04-19-2017

Re: How to change date format from MM/DD/YYYY to DD/MM/YYYY in Power BI Service?

@Simon_Hou-MSFT

 

Thanks for the response! I've seen few submissions for Zuora to be integrated yet no responses for those.

 

I'll submit one myself and see how we go.

 

As for the text column to change, we are using Zuora as a billing engine for electricity metering/usage. The data that we receive from our service provider is set in a way that we can't readily change. We are hoping more of a solution that would take out the need from extracting data ourselves from Zuora to put into pbi - to make it more autonomous.

 

Best Regards!

Frequent Visitor
Posts: 2
Registered: ‎06-19-2017

I Re: How to change date format from MM/DD/YYYY to DD/MM/YYYY in Power BI Service?

Hi

 

I just found the answer which was obvious....after I read it....but certainly not before Smiley Very Happy

 

https://community.powerbi.com/t5/Desktop/How-to-convert-dd-mm-yyyy-to-mm-dd-yyy-or-any-date-format-i...

Frequent Visitor
Posts: 2
Registered: ‎06-19-2017

I Re: How to change date format from MM/DD/YYYY to DD/MM/YYYY in Power BI Service?

Hi

 

I just found the answer which was obvious....after I read it....but certainly not before Smiley Very Happy

 

https://community.powerbi.com/t5/Desktop/How-to-convert-dd-mm-yyyy-to-mm-dd-yyy-or-any-date-format-i...