Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
@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
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
@plaidDK,
You can follow the steps in the blog above to create streaming dataset. Which step do you get issue?
Regards,
Lydia
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.