With the help of Slidescope’s Data Engineering team we have prepared sample JSON API
👉 https://coursetraining.in/jsonstore/data.php?s=orders

You can connect Power BI to this live JSON data in just a few steps.

✅ Steps to Load Live JSON from URL in Power BI

🔧 In Power BI Desktop:

1. Open Power BI Desktop
2. Click on Home > Get Data > Web
3. In the popup:
   • Choose Basic
   • Enter the URL: https://coursetraining.in/data.php?s=orders
   • Click OK
4. Power BI will fetch and recognize the JSON structure
5. It will show something like: List Record Table Click on “To Table” if needed, and expand columns using the expand icon (⤵️) in the header.
6. Rename and clean columns as needed
7. Click Close & Apply to load into your Power BI report

🔁 To Load people and returns

Repeat the same process using:

• https://coursetraining.in/data.php?s=people
• https://coursetraining.in/data.php?s=returns

💡 Pro Tip: In the Power Query Editor, you can rename these queries as Orders, People, and Returns.

🔄 Refresh Behavior

• Power BI will refresh data from the live URL each time you click “Refresh”
• To auto-refresh every X minutes, you’ll need Power BI Service + gateway setup (for online reports)

⚠️ Make Sure:

• Your server has CORS enabled if you’re calling this in Power BI Online (optional but ideal for service refresh).
• The URL is publicly accessible without login or tokens.

Let me know if you’d like:

Or merging data using relationships in Power BI (e.g., Join Returns on Order ID)

These 3 JSONs as separate endpoints

Help with refresh scheduling