COE Toolkit Admin Task Power BI report TDS error

[veera_web]

I am trying to upgrade COE Toolkit with September 2022 release. When opening the 'Power Platform Administration Planning.pbit' in PowerBI Desktop app connecting to my environment 'org123.crm.dynamics.com' gives the attached error message.

As per the existing issue raised here https://github.com/microsoft/coe-starter-kit/issues/3636  which suggests to open TCP port 1433. But its not possible for unblocking port 1433 inside a corporate network.

Can we suggest COE toolkit Power BI team to use normal protocol as all other COE power BI reports works without TDS.

Or any other workarounds PP guru's welcome.

[v-rzhou-msft · Accepted solution]

Hi @veera_web ,

As far as I know, to use the Dataverse connector, TCP ports 1433 and/or 5558 need to be open to connect.

If only port 5558 is enabled, you must append that port number to the environment URL, such as yourenvironmentid.crm.dynamics.com:5558.

Or you can try to open Port 1433 temporarily to build the dashboard in Power BI Desktop.

Best Regards,
Rico Zhou

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