Datamart schedule refresh does not work

[osama_ayoub]

Hi,

I have created datamart and this datamart is calling power app dataflow, the power app dataflow is changed continuously so I have set datamart to schedule refresh to always get the last update from power apps dataflow
in the refresh history there is no problem but in fact the data is not updated and I must enter the datamart and refresg it and press save to get the last update.

Any Ideas ?
Regards

[v-zhengdxu-msft]

Hi @osama_ayoub 

Ensure that your datamart's scheduled refresh is correctly set up. As per the documentation on managing datamart refreshes, you can configure the scheduled refresh from the datamart settings page. Double-check to make sure the schedule is correctly configured to meet your update requirements.

There's a known issue where scheduled refreshes might be skipped for datasets connected to a dataflow, as mentioned in the documentation. Although the schedule time appears correct, the refresh might not actually take place. A workaround for this issue is to republish the dataset under a different name to the same workspace.

Known issue - A scheduled refresh of a dataset intermittently hangs when connected to a dataflow - M...

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[osama_ayoub]

Ok
I have created a report containing only the dataflow from power app and I have published it , then I set up the schedule refresh 
and to ensure it will work fine I have removed column from the power app dataflow and published it again , now when the dataset refresh has failed and I got the below error massage which is the same massage in the datamart by the way (the column Index does not found)
thanks for your help

[v-zhengdxu-msft]

Hi @osama_ayoub 

Please refer to the below link which has similar issue:

Solved: Column does not exist in the rowset error - Microsoft Fabric Community

Solved: Re: The 'HasUniqueRoleAssignments' column does not... - Page 2 - Microsoft Fabric Community

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[osama_ayoub]

the problem is the same when I refresh the datamart manually it works fine and the change in the power app dataflow is updated in the datamart without any error but when I set schedule refresh it does not reflect any change in the dataflow until i refresh it manually.