Custom API

[jyaul786]

Hello

i have one custom API(XML) running on my localhost and getting streaming data, how can connect  API to Real time streaming in power bi dashboard

i have two fields, in api: name & time.

[ibarrau]

Hi. In order to build a streaming report you might want to read more about "Streaming Datasets". You can create datasets with a single table delimiting columns. Once created you can just post request data on it. So in your custom API environment you can create a small script to send new rows everytime. Once the dataset is working you can create a report and pin visuals to dashboard. Consider that only dashboards show live data, reports need a visual refresh to show last data (just in case you plan showing on tv or something like that).

You can read more about it in the doc: https://learn.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming

This is an example using python and sending more than one row: https://blog.ladataweb.com.ar/post/612206236078899200/python-power-bi-en-tiempo-real-lote-con-pandas

I hope that helps,