Forum Discussion

BobRasta's avatar
BobRasta
New Member
1 year ago
Solved

Error while processing data in dataset

My dashboards aren't updating after publishing to the Service. In Power BI Desktop, I can authenticate to the source using the M code without any problems. As a data source, I'm using the Microsoft...
Need Help
  • v-tejrama's avatar
    v-tejrama
    11 months ago

    Hi again BobRasta ,

     

    Thank you for confirming the checks you have completed. Since your SQL dataset is refreshing properly, the gateway appears to be functioning as expected. The issue seems to be with the JSON and API setup, as the Service cannot access a local file path directly. Saving the API data into SQL or another always-accessible source is recommended and should resolve the refresh issue. Let us know how it goes after you test with SQL.

    Thank you,

    Tejaswi.

     

Mauro89's avatar
Mauro89
Super User
1 year ago

Hi BobRasta 

 

The fact that it works fine in Power BI Desktop tells me that the query and authentication are good locally — the issue is in the Service-to-Gateway connection path.

 

Here’s how I’d troubleshoot step-by-step:

 

1. Check if the Gateway is Online

 

  • Open Power BI Service → Settings → Manage gateways.
  • Ensure the gateway shows Online and the same gateway is mapped to your dataset’s data source.
  • If it’s Offline, restart the On-premises Data Gateway service on the host machine (services.msc → “On-premises data gateway service”).

2. Verify Data Source Mapping

  • In the Gateway connections tab for your dataset, make sure:
    • The JSON file source path exactly matches the one in Power BI Desktop (including drive letter and slashes).
    • The Data Source Type matches (File, Web, etc.).
  • If the path on your machine is C:\Users\you\Documents\data.json, the gateway machine must have that same file path accessible.

3. Check Gateway Host Accessibility

  • The Service can’t directly “pull” from your PC — the gateway machine must be able to reach:
    • The JSON file on your machine (network share may be needed if the gateway isn’t installed locally).
    • If the file is on your OneDrive, make sure it is up and running
    • Microsoft Graph API endpoints (ensure firewall/proxy allows outbound HTTPS)

I hope this helps you troubleshoot. If yes feel free to mark my post as solution. 

Best regards!