Auto-refresh report (not dataset) on a Teams Room Device.

[DorienM]

Hey all, I have a number of reports configured in import mode published to the PowerBI service. They draw data from an on-premise data source through a data gateway. I have configured scheduled refresh for the dataset in PowerBI service and the dataset now refreshes once every three hours.

What I am wondering is this, can a user also have a report open on a Teams Room device and schedule the report itself to refresh automatically on a scheduled interval? I don't care about refreshing the dataset as that is already happening separately on its own, I just want to know if there is a way to set up what is essentially an F5 refresh for a report on a Teams Room device.

[v-xiaoyan-msft]

Hi @DorienM ,

This does not affect your ability to configure other refreshes, as your report refreshes in the embedded to Teams Room do not trigger the gateway until the refresh in Power BI Service is triggered, and you refresh the report information already provided by PowerBI.

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[DorienM]

Hi @v-xiaoyan-msft,

Thanks for the reply, what I am looking to find out is how do I actually configure automatic report refresh on a Teams Room embedded report?

The use case is fairly simple, we have a Surface Hub that is going to be put into an executive's office. They want to be able to pull up a report, leave it on screen and have it automatically refresh throghout the day without any interaction. Is this possible, if so how do I set that up?

Regards,

Dorien

[v-xiaoyan-msft · Accepted solution]

Hi @DorienM ,

Based on the information you provided, your needs cannot be met.

There is a limit to the number of times a scheduled refresh report can be refreshed in a day, and Directquery is the best option. You can use Directquery to create your dataset and it will automatically refresh when people view the report. But you mentioned that reports don't have interactions, so this problem becomes tricky.

When a report doesn't have any interactions, it doesn't trigger a query and the report can't be refreshed.
The bottom line is that your report is in import mode, and unless you complete a scheduled refresh in Power BI, or re-upload it after updating the content, the report won't change.

Best Regards,
Community Support Team _ Caitlyn

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.