Hi community,
I have the "export to data lake" from https://make.powerapps.com/ activated. I'm exporting some entities of my dynamics crm to azure data lake gen 2. There are big entities like contact or account involved.
I'm accessing those datasets with powerbi and builded reports and dashboards based on this logic.
Since there are a few data transformations involved and a lot of data to be downloaded, it takes powerbi service around 2 hours to process the refresh.
But at the end of the 2hours processing, it appears that the data lake date has been changed, since there ihappend an opdate in the dynamcis data. The refresh fails with the "source data has been changed" error message.
What can I do, to resolve this issue?
It would be ok for me only sync dynamics data one time a day (cant find such an option in the settings of the data lake connection) so that the source data doesnt change. It would be even better, if I could refresh and "cache" the whole data, so powerbi doesnt check if the source data has changed. I hope it gets clear what I want to express.
Are there any ideas out there? Thanks!
