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.

     

BobRasta's avatar
BobRasta
New Member
11 months ago

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's avatar
v-tejrama
Community Support
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.

 

  • v-tejrama's avatar
    v-tejrama
    Community Support
    11 months ago

    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.