Forum Discussion
Datamart schedule refresh does not work
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.
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.
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
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.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.