In live streaming how to implement REST API with datasource?

[Vaishali04]

Hi All,

I want to know about how does REST API works with AZURE SQL DB to fetch data  in POWER BI SERVICE. Where I need to code the API to fatch data from db and how to reshedule API ?

What to use POWERSHELL, curl, ...to fetch data from db ?

If anyone has idea about this please help.

Regards

Vaishali

[v-lili6-msft · Accepted solution]

hi  @Vaishali04 

To my knowledge, it could not achieve in power bi.

There are three primary ways you can push data into a dataset:

• Using the Power BI REST APIs
• Using the Streaming Dataset UI
• Using Azure Stream Analytics

https://docs.microsoft.com/en-us/power-bi/connect-data/service-real-time-streaming#pushing-data-to-d...

Regards,

Lin