Forum Discussion

Dewang's avatar
Dewang
Frequent Visitor
8 months ago
Solved

Unable to Store Credentials for Cloud Source: Data Source Credentials Option Disabled (Grayed Out)

Hello,   I am connecting to the tables in Microsoft Fabric Lakehouse in Power Bi using SQL Analytics Endpoint.   I am able to refresh the data in Power BI Desktop which means the connection is pr...
Need Help
  • rohit1991's avatar
    rohit1991
    8 months ago

    Hii Dewang 

     

    The Data Source Credentials option is grayed out because your semantic model is still using the default connection created in Desktop, which doesn’t store cloud credentials in the Service.

    To fix it, open the model in Power BI Service >> Settings >> Data connections, remove the default connection, and add a new explicit cloud connection to your Lakehouse/SQL endpoint. Once this connection is created, the credentials section becomes active and the refresh error is resolved.

rohit1991's avatar
rohit1991
Super User
8 months ago

Hii Dewang 

 

The Data Source Credentials option is grayed out because your semantic model is still using the default connection created in Desktop, which doesn’t store cloud credentials in the Service.

To fix it, open the model in Power BI Service >> Settings >> Data connections, remove the default connection, and add a new explicit cloud connection to your Lakehouse/SQL endpoint. Once this connection is created, the credentials section becomes active and the refresh error is resolved.