Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Is anyone running into similar issues with dashboard sourced out of SSAS connector?
Any advice to point to the source of the issue is highly appreciated!
The one behavior that I noticed, possibly has impact on dashboard tiles refresh.
select [date_modified] from $system.dbschema_catalogs where [catalog_name]='Model database name')
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.
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.
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)
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.