Realtime dashboard with Json

Question

Hello,&nbsp;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.&nbsp;So basically i need my dashboards to refresh real time based on new data coming into my json file.Thanks!&nbsp;

anonymous · Answer

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 · Answer

Hello Lydia,&nbsp;Thanks for your response. My JSON is created from an SQL Server to a JSON File. How would the process then be?&nbsp;Thomas

anonymous · Answer

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

Forum Discussion

Realtime dashboard with Json

3 Replies

Related content

Realtime Reports

Alerts on Realtime dashborad using activator

SAP realtime integration with Fabric

Can Realtime Dashboard show visuals based on data models

Synapse Realtime analytics