Forum Discussion
Error while processing data in dataset
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.
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.
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.
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.