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
@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
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.