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 have got the exactly the same problem! I can see in the profiler the service polling SSAS using

 

select [date_modified] from $system.dbschema_catalogs where [catalog_name]='catalog_name'

 

but the tiles aren't refreshing at all. Fingers crossed this is fixed for GA on Friday.

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
    Icon for Super User rankSuper 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.