Forum Discussion
Use SSAS report as an auto-refreshing dashboard
Hello,
We have an on-prem PowerBI Report Server and we are developing a report with a Live Connection to SSAS cube.
We want to set-up this report to work as a kind-of operational dashboard with auto-refresh of the data as the data changes in SSAS cube.
Is it possible with on-prem PowerBI Report Server and a report with a Live Connection to SSAS cube?
6 Replies
- d_gosbell
Super User
If what you want is to run a report on a screen somewhere and have it auto-update without any user interaction then this is not currently possible in PBIRS.
They have started adding this sort of functionality to the cloud service, but there is no indication if or when this might come to PBIRS. One work around would be to use some sort of browser extension to trigger a refresh of the browser page based on a timer, that would then pull the latest data from the SSAS model.
RT3308Helper I
Hello... what's the status of this now? Is this now available for PBIRS? How about in Cloud Service... what's the lowest auto-refresh rate? I've seen in some articles it's 15min... but this is not good enough. Is there a way to set it to closer to real-time?
- d_gosbell
RT3308 wrote:
Is there a way to set it to closer to real-time?
There have been no changes to this in PBIRS. If you want true "real-time" you can do that in the service with streaming datasets. see https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming
- RT3308
Thanks for the reply...
Actually - we have the same setup in PowerBI Cloud Service connected to SSAS through On-Prem Gateway. I've seen some articles to set it to auto-refresh but the dropdown can only go up to 15min as its lowest value. Is there a way to refresh the visuals (connection to SSAS through the gateway) in PBI Cloud Service?
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-automatic-page-refresh
