Microsoft Graph Security conector update error

[SEACHAD]

Hello ,

I have developed a report using the Microsoft Graph Security conector.

When I test it on desktop and change the user credentials it works properly  but when published it, and use the same report but in two different workspaces, each one with different user credentials an dprograman automatic update, the both reports take the same credentials (results). This reports also have conections with another data sources and the update works properly and each report reflects tha data corresponding with its credential.

Does the Power Bi service store the credentials in any internal buffer? 

Last but not leastm, some times, when I  try to update the credential appear the mesage

"No se pudieron actualizar las credenciales de origen de datos: [invalid_grant] AADSTS54005: OAuth2 Authorization code was already redeemed, please retry with a new valid code or use an existing refresh token. Trace ID: 5ad9c7f5-074c-443d-b762-065072051300 Correlation ID: f07737e0-7aa6-43cd-8d14-72aa98e8ef2e"

Thank you in advance

Best regards

[Anonymous]

Hi @SEACHAD ,

Are you using the on-premises data gateway to refresh data? If so you can refer to the 5th step of the following document.

https://docs.microsoft.com/en-us/power-bi/service-gateway-sql-tutorial#connect-a-dataset-to-a-sql-se...

And you need to create different data sources with different credentials for your datasets.

Best Regards,

Jay

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.