I have a data source residing in On-Prem and Gateway is installed in Cloud. On some occasions, we are observing that our schedule refresh on the power bi service is failing.
We are noticing the below error
Microsoft SQL: The server principal "agc_rp" is not able to access the database "optprd" under the current security context.
For some reason the agc_rp is trying to access the database "optprd", we use completely a different database.
Please advise where we can find the configuration related to "optprd".
I seen the article which says that we need to provide Connect Permission to "optprd", but in our case we are not at all using the "optprd" at all.
Appreciate your help and thanks in advance.