Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Can someone please explain the rules around dashboard refresh times? We have dashboards connected to an on premise SSAS Tabular model, using the Enterprise Gateway. The model is refreshed every morning, and finishes around 8:00am.
The is what I have experiences so far:
I accept that it may take 30 minutes or so to automatically update dashboard data, but surely if someone manually selects the refresh options, it should be going to the server and getting the most recent data, rather than continuing to use cached data.
Is my experience the same as other users, or is there potentially something wrong at our end?
This post is getting losts of views but no responses. Does that mean that no one else is experiencing any problems with dashboard tiles refreshing?
I have set up a new test. I have a new, simple model (on prem SSAS tabular). It has some dimensions which are calculated columns that extract the current Year, Month, Day, Hour, Minute and Second:
=Year(now())
=Month(now())
=Day(now())
=Hour(now())
=Minute(now())
=Second(now())
I have set up a sql job to process the cube every 5 minutes, and created a Power BI report & dashboard that simply displays the columns in a table. I am seeing similar behaviour as I explained in my original post - the dashboard tiles do not seem to be updating. Is there anyone - maybe someone from MS - who understanding how On Prem data should be updating on dashboard tiles. If I choose the 'Refresh' option when dislaying a dashboard on either my iOS app or the web site, surely it should go the on prem server and get the latest data, rather than using cached data from somewhere?
I would really appreciate any comments or feedback from anyone who is using the Enterprise Gateway with on prem SSAS tabular data. Are we the only ones experiencing this type of problem? Are we the only ones really using the functionality?
Few things that i noticed in recent days:
- When we create a report first and pin some element to a dashboard, then the dashboard elements do not update automatically even if the report data is updated. What we are doing is that after making updates in the report, we need to delete the existing element from the dashboard, and repin the element back to same dashbaord to view the changes made.
- When working with Group Workspaces, there are few issues with data integration from various sources. Often we realized that things working on the personal workspace wont work in same way in a Group Workspace (we were working on integration of Excel Spreadsheet from One Drive with Power BI report).
Same issue faced...
I have to everytime refresh the data at report level but still the refresh numbers do not reflect at the dashboard.
Either I have to pin the tiles again to the dashboard or click refresh now option.
Please help in resolving this issue asap.
I have the same issue.
Does anybody knows if this is resolved?
User | Count |
---|---|
64 | |
27 | |
25 | |
17 | |
11 |