Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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
Thanks a lot for your answer
Unfortunately, the issue is still exist
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
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
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.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.