topic Re: Power BI report server live connection/ real time streaming data in Report Server

Power BI report server live connection/ real time streaming data

Jessica_17 — Tue, 10 Dec 2024 09:22:34 GMT

Hello All,

I have a query, can we have a live connection with Power BI report sever, where the data gets refreshed automatically in visuals at server side link, without clicking on refresh button or anything and it has a live connection with SSAS services.
Baiscally act like real time streaming data. Can anyone please help me in this?

Thanks,

Jessica

Re: Power BI report server live connection/ real time streaming data

Vanchy_Liao — Wed, 11 Dec 2024 01:58:32 GMT

Jessica_17 ,

According to the document, you can access the SSAS through pbi desktop and pbirs.

https://learn.microsoft.com/en-us/power-bi/report-server/data-sources#list-of-supported-data-sources

If you check the PBI Desktop for RS, you can choose "SQL Server Analysis Services database" from " Get data".

then you will see the "Import" mode and "Connect live" mode. Choose "Connect live" mode which won't download the data storing into your .pbix.

You can reuse the sematic model existing in SSAS.

https://learn.microsoft.com/en-us/power-bi/connect-data/service-live-connect-dq-datasets#live-connection

Re: Power BI report server live connection/ real time streaming data

Anonymous — Wed, 11 Dec 2024 02:01:57 GMT

Hi, Jessica_17

Power BI Report Server doesn't directly support streaming datasets, but you can use the Power BI service to create a streaming dataset and then embed the report into Power BI Report Server. This approach allows you to take advantage of real-time data streaming capabilities. You can check the following link:

Real-time streaming in Power BI - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

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

Re: Power BI report server live connection/ real time streaming data

Jessica_17 — Wed, 11 Dec 2024 06:18:04 GMT

Hi Vanchy_Liao ,

Thanks, but even after doing live connection, we have to click refresh button on report server side to get the data refelected, it doesn't automatically refreshes, while I was deep diving into license structure, I got to know that we can publish it into server, but does it store data in cloud, becaused my clients concern is , that the data should not be in cloud, but data should refresh as real time streaming data, and can be embedded anywhere.
Can you tell me workaorund for this.

Re: Power BI report server live connection/ real time streaming data

Jessica_17 — Wed, 11 Dec 2024 06:19:30 GMT

Hi Anonymous ,

Thanks for the reply, but my clients requirement is that the data should not be in cloud, but data should refresh as real time streaming data and can be embedded anywhere, can you please help me in that.

Re: Power BI report server live connection/ real time streaming data

Vanchy_Liao — Wed, 11 Dec 2024 07:01:35 GMT

Jessica_17 ,

As i know, the Fabric has some setting pages which you can set some criteria to trigger it.

Automatic page refresh in Power BI Desktop - Power BI | Microsoft Learn

What is Real-Time Intelligence - Microsoft Fabric | Microsoft Learn

You can see that Power BI Service achieving "Real-Time" is by setting scheduler to query data.

Perhaps you shall customize a web portal to achieve "Real-Time" like report refreshing.

And monitor what will the "Refresh" button on report page do after clicking.

It is really hard to develop report for PBIRS.

PBIRS just a loader for .pbix and don't expect it too much.

I have been hurt by PBIRS many times.

Re: Power BI report server live connection/ real time streaming data

Jessica_17 — Wed, 11 Dec 2024 07:24:33 GMT

HI Vanchy_Liao ,

Thanks for the reply, but if we do this configuration in server, aren't we adding data in cloud ?
As the client is stuck on On-Premise server as they do not want the data in cloud and it should be live over there only and they do not want to spend a single penny on license on fabric also

Re: Power BI report server live connection/ real time streaming data

Vanchy_Liao — Wed, 11 Dec 2024 10:31:30 GMT

Jessica_17 ,

To more clarify my suggestion, i assume your client use all on-premise servers including SSAS and Power BI Report Server.

Solution 1:

Asking your client to get used to click "Refresh" button when viewing report if they insist the data can not be uploaded to cloud.

Solution 2: Create a website

1. upload the .pbix to PBIRS which data source is from SSAS.

2. enter the report and press F12 to monitor the actions after pressing "Refresh" button.

3. create a website and embed the report into an iframe.

4. write a js code to send the requests (step 2) or implement webhook.

Re: Power BI report server live connection/ real time streaming data

Jessica_17 — Wed, 11 Dec 2024 11:35:55 GMT

HI Vanchy_Liao ,

Thanks for the solution, I asked one JS developer, and tried it, but now the issue is, they have to write code in console, or when writing in script whole page loads, which does not seems like an ideal refresh. And when we embed it, the whole report in website gets refreshed. Not sure , how can we resolve it.