Realtime dashboard with Json

[plaidDK]

Hello,

I have heard that it is possible to have your dashboard refreshed automatically (in real time) with Json file and the REST API? I have watched serveral videos on how to do this, but only found a way to import data with a json file. How would i go on with this? I dont have much experience with REST API.

So basically i need my dashboards to refresh real time based on new data coming into my json file.

Thanks! 

[v-yuezhe-msft]

@plaidDK,

Do you get data from local JSON file or a JSON file generated from web application? You can use Power Query to push data from JSON file to streaming dataset, which is easier. For more details, please review the following similar blog.

https://blog.crossjoin.co.uk/2016/11/08/pushing-data-from-excel-to-power-bi-using-streaming-datasets...

Regards,
Lydia

[plaidDK]

Hello Lydia,

Thanks for your response. My JSON is created from an SQL Server to a JSON File. How would the process then be?

Thomas

[v-yuezhe-msft]

@plaidDK,

You can follow the steps in the blog above to create streaming dataset. Which step do you get issue?

Regards,
Lydia