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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
ManoukUBN
Frequent Visitor

Unable to configue existing data sources or add new from a cloud source

In the powerBI service, I can't use the existing data sources, or add a new cloud source.

 

When checking the status of the existing data sources, I get the following error:

 

Foutcode: DMTS_DatasourceHasNoCredentialError
Gegevensbronfout: Gegevensbron heeft geen referenties
Cluster-URI: https://api.powerbi.com
Activiteit-id: 4fc9489a-15cb-47ed-af03-e066358d8d73
Tijd: Thu Apr 06 2023 11:50:32 GMT+0200 (Midden-Europese zomertijd)

 

When trying to verify my credentials, the verification methods dropdown menu is blank, making it impossible to repair it.

 

Then, if I want to add a new data source, the "Cloud" option is grey. Can't select it at all.

 

I'm not limited through the tenant settings, and have most administrative rights. Even my admin account, which should have full access, can't add new cloud data sources.

 

Thanks in advance for the help!

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @ManoukUBN ,

Are you connecting to the Excel file like this?

Solved: Use Excel file from Microsoft Teams as data Source

 

//After changing my password I get these error message:

1.On the desktop you can: Transform data -> data source setting -> Clear Permission -> Edit permission -> Re-enter credentials.

vrongtiepmsft_0-1681179572108.png

 

vrongtiepmsft_1-1681179585861.png

2. In Service: Workspace -> dataset -> more options(...) -> settings ->data source credentials -> edit credentials.

vrongtiepmsft_2-1681179607353.pngvrongtiepmsft_3-1681179617321.png

 

I have also found a similar post, please refer to it to see if it helps you.

Solved: Re: DMTS_DatasourceHasNoCredentialError - Microsoft Power BI Community

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details .

 

Best Regards
Community Support Team _ Rongtie

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

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @ManoukUBN ,

Are you connecting to the Excel file like this?

Solved: Use Excel file from Microsoft Teams as data Source

 

//After changing my password I get these error message:

1.On the desktop you can: Transform data -> data source setting -> Clear Permission -> Edit permission -> Re-enter credentials.

vrongtiepmsft_0-1681179572108.png

 

vrongtiepmsft_1-1681179585861.png

2. In Service: Workspace -> dataset -> more options(...) -> settings ->data source credentials -> edit credentials.

vrongtiepmsft_2-1681179607353.pngvrongtiepmsft_3-1681179617321.png

 

I have also found a similar post, please refer to it to see if it helps you.

Solved: Re: DMTS_DatasourceHasNoCredentialError - Microsoft Power BI Community

 

How to Get Your Question Answered Quickly 

 

If it does not help, please provide more details .

 

Best Regards
Community Support Team _ Rongtie

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

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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