Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

LigalTuval

Report Data Not Being Refreshed

Submitted by Microsoft Employee on ‎10-11-2022 01:13 AM

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
See more ideas labeled with:
3 Comments (3 New)
Comments
Anonymous
Not applicable
‎10-11-2022 11:27 PM

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
Microsoft Employee
‎10-12-2022 12:47 AM

@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
‎10-13-2022 12:19 PM

@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

 

Idea Statuses