Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
fschaaf
New Member

Zuora

When using the native Zuora integration, more than 50% of the imported dates are "NULL".

Example: Rate Plan Charge Effective Start Date is "NULL" in about 3000 objects. (We have about 4500 subscriptions)

In the original data (observable through the zuora UI) "NULL" does not occur as a value for these dates.

I am thus unable to filter the data the way I need.

 

Screenshot

 

1 ACCEPTED SOLUTION

FYI: I solved this by creating a new API User in Zuora with US Locale and using this user for the integration.

View solution in original post

2 REPLIES 2
fschaaf
New Member

Looks like the dates get imported with day and month mixed up, resulting in all the dates with day > 12 becoming "NULL". And all the dates are wrong, of course.

How can I fix this?

FYI: I solved this by creating a new API User in Zuora with US Locale and using this user for the integration.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors