Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Reply
Anonymous
Not applicable

Azure SQL data source for SSAS (faild authorisation)

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

 

3 REPLIES 3
Anonymous
Not applicable

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

Hi @Anonymous 

Thanks for your reply.

Have you edited your credentials?

vxiaotang_0-1635239458293.png

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
Community Support
Community Support

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

vxiaotang_1-1634283776614.png

 

 

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors