cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gee434
New Member

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 hours of interval.  Sometimes longer or shorter this but there is no consistency.
  • The on-prem tabular model is refreshed every 30 mins
  • The drill down from dashboard to report pulls the latest numbers always
  • Profiler indicates that the connection comes in to SSAS but not every 15 mins.  Not every hit refreshes the dashboard.
  • No errors on event logs on the server (SSAS & connector running on the same server)
  • Contacted support many times, waiting for update / resolution

Any advice to point to the source of the issue is highly appreciated!

 

 

 

5 REPLIES 5
Gee434
New Member

The one behavior that I noticed, possibly has impact on dashboard tiles refresh.

  • The PowerBI is running DMV query to check the schema (and expects more recent date timestamp?)

select [date_modified] from $system.dbschema_catalogs where [catalog_name]='Model database name')

  • This date gets updated only when the tabular model is processed from SSMS (ProcessFull or ProcessRecalc). It is not updated when the processing is launched from SSIS package in XLMA mode through script task or XMLA is run from query window.
  • PowerBI then terminates the connection instead of running DMX queries to refresh.
  • When I process the model from SSMS manually, then the next check, runs the DMX queries and refreshes the tiles.
  • PowerBI checks do not come in every 15 mins for sure. (Came in at 11.08 AM and then 2.13 PM for example)
  • Have not figured out a way to force the date_modified which corresponds to Last Schema update from script. Only the Last processed date/time gets updated.

Hope this gets fixed as we are exclusively using SSAS On-prem as data source.

 

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.

 

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

Capture.PNG

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.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




andre
Memorable Member
Memorable Member

I believe that the tiles are suposed to refresh every 10 minutes or so.  If they are not, I am guessing it is due to the same refresh issue that has been reported in a number of posts over the last couple of days.  Lots of new changes have been deployed to the service over the last several days so let's hope all these issues are stabilized by the GA next week.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors