Several errors occured during data refresh. Please try again later or contact your administrator.

[jtech1343]

Data won't refresh until I refresh on the desktop then hit the refresh button on the server. No problems with the testing connection, and updates fine in the desktop version.

[v-achippa]

Hi @jtech1343,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @rohit1991 for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @jtech1343,

We wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @jtech1343,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

Thanks and regards,

Anjan Kumar Chippa

[rohit1991 · Accepted solution]

Hi @jtech1343 ,
The error you're encountering during data refresh in the Power BI Service is primarily due to invalid credentials for the SQL data source, as indicated in the error message. While the dataset refreshes successfully in Power BI Desktop, the service relies on credentials configured through the on-premises data gateway to connect to your source, and those may be outdated or incorrectly set. 

To resolve this, go to the dataset settings in the Power BI Service, check that the correct gateway is connected and online, and then re-enter or update the data source credentials under the "Data source credentials" section. Additionally, ensure that the source mapping in the gateway matches exactly with what’s used in your Power BI Desktop file. Once the credentials are properly configured, the scheduled and manual refreshes should work without needing to refresh from the desktop each time.

Passionate about leveraging data analytics to drive strategic decision-making and foster business growth

Connect with me on LinkedIn: Rohit Kumar