cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
thgood1 Frequent Visitor
Frequent Visitor

Refresh PowerBI Report when SSAS Table is Processed

We have PBRS connected via DirectQuery/Live to a Tabular SSAS server which in turn gets its data from MSSql via import (not direct query).   On the SSAS server, I have a table partition which is processed every 10 minutes.   I'm looking for a way to get my PowerBI report to reflect the changes as soon as the table partition is processed.    I understand streaming API may be an option but everything is working except I have to manually refresh the PowerBI html page (PBRS embedded) to see the changes.

 

I'm using the October release and I've tried some of the settings on this page, but I'm not sure I'm on the right path?

https://docs.microsoft.com/en-us/power-bi/report-server/scheduled-refresh-troubleshoot

 

2 REPLIES 2
Highlighted
Moderator v-qiuyu-msft
Moderator

Re: Refresh PowerBI Report when SSAS Table is Processed

Hi @thgood1,

 

To work around the issue you can utilize the browser auto refresh add-in, eg: https://chrome.google.com/webstore/detail/auto-refresh/ifooldnmmcmlbdennkpdnlnbgbmfalko

 

Also you can submit a feedback here: https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thgood1 Frequent Visitor
Frequent Visitor

Re: Refresh PowerBI Report when SSAS Table is Processed

Qiuyun,


Thank you for the response,  I currently have the dashboard setup on an embedded linux kiosk with a refresh every five minutes (via F5 keystroke automation).  There are challenges to that approach:

 

1) It adds delay since we don't know exactly when the table will finish processing.  For our manufacturing operation, this is especially critical at the end of the production shift.

 

2) The extension triggers a full page reload.  This is slow on the kiosk and is much slower than the built-in refresh button within the report server interface. 

 

Connecting PBRS to tabular SSAS seems like the most enterprise-ready deployment, as such, I would like to see better support for the tabular SSAS solution when processing a table.  

Helpful resources

Announcements
Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Power BI Helps Homeless and Trouble Youth

Power BI Helps Homeless and Trouble Youth

We spoke with Power BI Super User, Greg Deckler, about his charity work

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 41 members 996 guests
Please welcome our newest community members: