Error while processing data in dataset

[BobRasta]

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 Graph API and a JSON file hosted on my PC.
I have a Gateway configured and connected to the JSON.
The error is as follows:

Data source error: {"error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","pbi.error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","parameters":{},"details":[],"exceptionCulprit":1}}} Table: Assignments.
Cluster URI: WABI-BRAZIL-SOUTH-B-PRIMARY-redirect.analysis.windows.net
Activity ID: 3f0b1b44-0e5a-48d7-9cf7-07edb1e0792d
Request ID: bdb46527-54ff-434a-bda1-e675da60dc68
Time: 2025-08-12 13:37:05Z

[BobRasta]

Verifiquei o Gateway, verifiquei o mapeamento da fonte de dados e verifiquei a acessibilidade do host do gateway. Tudo está correto, mas não está atualizando.
Eu tenho outro painel cuja origem é um banco de dados SQL e funciona corretamente. Portanto, primeiro tentarei salvar os dados da API em um banco de dados SQL e usá-los como fonte no Power BI.

[v-tejrama · Accepted solution]

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.

[v-tejrama]

Hi @BobRasta ,

Just checking in have you been able to resolve this issue? If so, it would be greatly appreciated if you could mark the most helpful reply accordingly. This helps other community members quickly find relevant solutions.

Thank you,

Tejaswi.

[v-tejrama]

Hi @BobRasta ,

Thank you @Mauro89  for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your understanding!

[v-tejrama]

Hi @BobRasta ,

I wanted to follow up and see if you had a chance to review the information shared. If you have any further questions or need additional assistance, feel free to reach out.

Thank you.

[Mauro89]

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!