Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
FYI: I solved this by creating a new API User in Zuora with US Locale and using this user for the integration.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
49 | |
19 | |
12 | |
11 |