Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Data source extension is missing credentials - Composite Model

Hi,

 

I've created a new report based on a Power BI dataset and a Dataflow. It works fine running in the Power BI Desktop on my machine. But in the Power BI service I get the error "The data source Extension is missing credentials and cannot be accessed".

 

 

According to other posts the error occurs because:
The error typically happens when the credentials of the dataset been changed.  Go to dataset setting in the credential section re-enter the credentials.

Because I've created a report using the composite model feature (shared dataset + dataflow) the report itself has its own dataset referring to the other sources. The "Data source credentials" setting of this dataset show the following error:

 

"The credentials for the data source type powerbi:// and asazure:// have already been set, but you can edit them if needed."

Failed to test the connection to your data source. Please retry your credentials."

 

 

The error refers to the dataset I'm connected with using Direct Query.

If I click on "Edit credentials" the following window opens.

 

 

If I click on sign in I receive a message that the data source has been updated. But nothing happens. The error still persists.

 

Can you tell me what to do in this case? Thanks a lot in advance.

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    I love when while looking for an answer I find the solution myself. ğŸ˜‚

     

    The thing I missed was that I needed to insert my credentials for the shared datset AND the dataflow separately. 

    I totally missed that "Edit credentials" is shown two-times.

     

    Thus, the mytsery is solved. 

     

    Cheers

9 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I love when while looking for an answer I find the solution myself. ğŸ˜‚

     

    The thing I missed was that I needed to insert my credentials for the shared datset AND the dataflow separately. 

    I totally missed that "Edit credentials" is shown two-times.

     

    Thus, the mytsery is solved. 

     

    Cheers

  • gasmioumaima's avatar
    gasmioumaima
    New Member
    2 years ago

    I've created a  report based on a Power BI dataset in Direct Query Mode from Dremio Software .

    It works fine running in the Power BI Desktop . But in the Power BI service , report server ;  I get the error "The data source Extension is missing credentials and cannot be accessed".  i tried to verify the credentials which is the same on pozer bi desktop  but it"s refused on Power Bi service 

     

     

     

     

  • shankar369u's avatar
    shankar369u
    New Member
    7 months ago

     

    If this error appears after publishing a report to Power BI Service, the cause is simple:
    the data source credentials were not configured in the Service.

    Fix

    1. Go to the Workspace.

    2. Open the Semantic model (Dataset).

    3. Navigate to File → Settings → Data source credentials.

    4. Edit and re-enter the required credentials.


    Why this happens

    Publishing a report does not automatically carry over credentials from Power BI Desktop.
    If credentials are missing or invalid in the Service, the dataset fails and throws this error.