I am new to the dynamics and power platform word. Forgive me my silly mistakes and ...maybe even approach.
The ultimate goal is to build a live report in Power BI based on data events from D365 Fin & Ops. We'd like to use the Power Platform integration for the finance and operations apps environment and propagate data events on certain tables to our Power BI Push dataset using some Power Automate flows.
We've actually done some work and it is almost fine. We built a flow in Power Automate to subscribe to events in Dataverse and push them to PBI. Create/Update/Delete events are correctly ingested into Power BI. In PBI we built some logic to find the latest state of rows and properly visualize the data.
In our case, the rate of events is not significant, so we don't suffer much from the limitations of the PBI push data set.
However, there are still some issues. There is actually a problem with proper serialization of events. Some details:
1. We use the RecId attribute to track changes to specific records.
2. We use the ModifiedDateTime attribute to order events. And here's the issue. The timestamp precision is only up to a second, while there are often cases where two consecutive changes are made to the same row within a second.
3. We also considered the attribute recVersion to order the events. The value changes after each CUD operation, however it seems that the version doesn't always increase (by whatever step). Some earlier changes result in a higher version than changes applied later.
4. Another issue is that some events seem to be propagated twice by Power Automate.
What would be the best option to properly order the events? Is there any option to get the ModifiedDateTime attribute more precise (e.g. up to milliseconds) ?
Maybe our approach is wrong and we should do that better?
Any recommendations/thoughts are welcome.
Regards,
Pit
