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 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

  • Gee434's avatar
    Gee434
    New Member
    11 years ago

    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.

     

    • 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

  • andre's avatar
    andre
    Memorable Member
    11 years ago

    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.