04-19-2017 10:38 PM
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,
04-20-2017 07:00 AM
04-21-2017 02:37 AM
04-23-2017 07:29 PM
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.
06-19-2017 11:29 PM
06-19-2017 11:31 PM
10-19-2017 08:15 PM
We are facing the similar issue right now. Could you please confirm the fix is avaliable for the issue or is it still in progress?
We are building Power BI dashboards on SSAS and when the reports are published to Power BI Online, Date format is converting back to "MM/DD/YYYY" format.
Also, I tried changing the date format for this field to "DD/MM/YYYY" at SSAS level and when the Power BI report is published we are noticing that the Table/Matrix in the dashboard is showing the values in "DD/MM/YYYY" but the report date filter still shows the format as "MM/DD/YYYY".
Any help or suggestion is much appreciated!!
01-23-2018 05:58 PM - edited 01-23-2018 06:20 PM
It is a little bit rustic solution, but you can split the date into separate columns in query editor > add column > Extract. Make separate column each for Month, Day and Year.
Then you can put together in the order you wish. I.e.: add custom column: