Azure SQL data source for SSAS (faild authorisation)

[Anonymous]

Hi guys how are you
I have an issue with automatic refresh my OLAP Cube (where one source is Azure SQL) 
When I deploy my project to the production server I can process my cube well during 1-2 hours 
but after this time I receive an issue 'The credentials provided cannot be used for the SQL source.'
then I redeploy my project and everything repeats again...

Help pls

[Anonymous]

Thanks a lot for your answer
Unfortunately, the issue is still exist

[v-xiaotang]

Hi @Anonymous 

Thanks for your reply.

Have you edited your credentials?

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-sql

Best Regards,

Community Support Team _Tang

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

[v-xiaotang]

Hi @Anonymous 

It looks like a scheduled refresh has been setup, and when the refresh plan runs, the Sql datasource can't be connected to. You need to configure the authentication for the data source(s) that are used in their report.

Here are 2 tutorial articles for your reference,

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources

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

Best Regards,

Community Support Team _Tang

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