Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Report Data Not Being Refreshed

I have a report built on top of a Datamart which I've created two weeks ago which has scheduled refresh once a day. 

When I'm opening the report, the latest data shown is from Oct 6th, but when looking at the Datamart there is data up until Oct 11 (which was the last time it was refreshed)

Status: Needs Info
Comments
Anonymous
Not applicable

Hi @LigalTuval 

Did you set some filters in report ? If you refresh the related dataset , will the data refresh in report ?

 

Best Regards,
Community Support Team _ Ailsa Tao
 

LigalTuval
Microsoft Employee

@Anonymous 

 

Yes. There is a filter by timestamp of type 'relative' for the last 14 days.

 

I have no option to refresh the dataset as it was created from datamart. The datamart source of data is Kusto

Anonymous
Not applicable

@LigalTuval & @Anonymous I'm having the exact same problem. I've found that the dataset that is autocreated from a datamart is not refreshing when the datamart refreshes. There's no way to refresh the dataset manually either. I also cannot use PowerAutomate to refresh the dataset (this will fail) and PowerAutomate doesn't yet have a connector to refresh Datamarts.

 

chase_henson_0-1665688769388.png