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.

     

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.