Cannot Connect to CDS by power bi desktop

[Frank_Fei]

Hi All,

Analyze in Power BI, I will get a .pbids file. However, I cannot connect to the CDS and got the error message. And I canot find the option to enable the function following the online document. btw, My account is Admin. I think that should be a bug?

[Frank_Fei]

[Greg_Deckler]

@Frank_Fei So, to be clear, you are getting that error when clicking that button? From the error you admin hasn't enabled the setting to allow it to happen. Probably need to check tenant settings in PowerApps/CDS instance.

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

[Frank_Fei]

@Greg_Deckler,

Can you have a try plz?

[amitchandak]

@Frank_Fei , Please check these if nor already done

https://staturestack.com/2020/05/22/using-sql-to-query-cds-data-login-failed-tds-protocol-endpoint-i...

http://mscrmtechie.blogspot.com/2020/05/using-sql-to-query-cds-data-login.html

https://github.com/MicrosoftDocs/powerapps-docs/issues/1365

[Greg_Deckler]

@Frank_Fei Wait, what am I trying?

[Frank_Fei]

To connect to CDS by my way.

[Greg_Deckler]

@Frank_Fei OK, what way is that, where are you? In admin.powerplatform.com?

[Greg_Deckler · Accepted solution]

@Frank_Fei - I think I figured it out:

These settings can be found in the Power Platform admin center by going to Environments > [select an environment] > Settings > Product > Features.