topic Use Pre-Existing Dataset To Update Streaming Dataset in Service

Use Pre-Existing Dataset To Update Streaming Dataset

Anonymous — Fri, 19 Mar 2021 00:52:10 GMT

We have a pre existing Power BI Dataset that is used in a report. We need a "Live Dashboard" - that can be put on display and doesn't need to be manually refreshed everytime.

We would like to use the pre existing dataset to populate a Streaming Dataset, without having to make REST API calls from our backend service.

Is this possible?

Re: Use Pre-Existing Dataset To Update Streaming Dataset

v-janeyg-msft — Mon, 22 Mar 2021 08:42:10 GMT

Hi, Anonymous

I don’t understand what you mean. If you don’t need real-time data, you can directly import the data, and then pin report visuals to the databoard. If you want to refresh, you can connect to the gateway.

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

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

Re: Use Pre-Existing Dataset To Update Streaming Dataset

Anonymous — Tue, 23 Mar 2021 03:02:55 GMT

v-janeyg-msft wrote:
If you want to refresh, you can connect to the gateway.

Can you elaborate on this please?

Am I to assume - a Pinned Report Visual is updated when the data set it reffers to, is refreshed? Meaning I could put the Dashboard on a screen and not have to manually refresh it every 5 minutes?

Thanks

Re: Use Pre-Existing Dataset To Update Streaming Dataset

v-janeyg-msft — Tue, 23 Mar 2021 06:02:25 GMT

Hi, Anonymous

You can't use the pre existing dataset to populate a Streaming Dataset. If data changes are not frequent, you can use import or DQ mode to connect data scoure and you need to configure the gateway to refresh,then you can set schedule refresh.

The dashboard refresh is not real-time, the browser will cache for one hour, if you use the DQ mode, you can set the time as fast as 15 minutes. Or you need to manual refresh.

Reference:Steps to configure Power BI Gateway | CloudFronts

Data refresh in Power BI - Power BI | Microsoft Docs

Best Regards

Janey Guo

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