Forum Discussion

Gee434's avatar
Gee434
New Member
11 years ago

SSAS Connector dashboard refresh issue

Is anyone running into similar issues with dashboard sourced out of SSAS connector? The dashboard tiles sourced from SSAS Connector is not refreshing as expected and very random at times 4 to 6 hou...
jonno232's avatar
jonno232
Regular Visitor
11 years ago

 

I didnt think to check this. Mine seems to be working better now.

Capture.PNG

dm-p's avatar
dm-p
Super User
11 years ago

I'm still having this issue since GA... for DirectQuery mode - drilling into reports shows "live" data. I'd tested with In-Memory but opted to switch out to DirectQuery so we can keep an eye on things within a window of 10 mins or so without having to constantly process our model (we found ~2 hours acceptable for most of our data but there are a couple of metrics we'd like to know about sooner).

 

This works just fine in the report view but the dashboard remains static unless I re-deploy the model to our SSAS instance (as it's DirectQuery, re-processing does not do anything) or navigate to the report and re-pin the items to the dashbopard, which is kind of onerous!

 

My other option would be to push these events via the API but as it's not a particularly huge dataset I felt that DirectQuery would probably give us a happy medium. I think for now I'll see if our folks are happy with moving back to In-Memory with a shorter processing interval.