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.
So that's my case.
We have a on-premises MySql connected to a dataflow with a Data Gateway and using incremental refresh.
The incremental refresh is set to archive last 10 years and refresh the last 2 months.
The MySql table has a DateTime Column and the data is updated once a week using a Python script that update or create the records in the table for the last week.
I've reviewed the database and I could see the new info in the database but after run the dataflow some records from the last week are missing.
So there's any way to look at this?
a Python script that update or create the records in the table for the last week.
That's not what incremental refresh is about. To emulate differential refresh you need to widen your hot update window (say, last 4 weeks instead of last week) and you need to plan for periodic full refreshes, also of older partitions.
a Python script that update or create the records in the table for the last week.
This is only trying to explain the general process, but the problem is in the incremental refresh, the script in python is just the way to feed the database
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 |
---|---|
52 | |
20 | |
18 | |
16 | |
9 |