Unable to run paginated reports due to rendering error

[StevenT]

HI, I'm getting this error.
Unable to render paginated report
There was an error contacting an underlying data source. Manage your credentials or gateway settings on the management page. Please verify that the data source is available, your credentials are correct and that your gateway settings are valid.

Is there a specific service that i should be connected to ? What do you guys usually use?
Here's the details of the my premises gateway (standard mode). My username is Desktop/stfro

[v-achippa]

Hi @StevenT,

Thank you for reaching out to Microsoft Fabric Community.

The gateway service on your machine is currently running as a local account (.\stfro). Local accounts cannot authenticate to remote sql servers. Please follow below steps:

• Change the report’s data source to use Sql Authentication(like username and password) so the gateway can connect immediately.
• Configure the gateway service to run as a domain service account which has a login on the sql server and the required database permissions.

After updating the service account, restart the gateway and test the data source connection again.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @StevenT,

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution I have provided for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa