Answered

Cannot connect to Dataverse tables

(1) Share

Report

Posted on by LW-18041150-0

I am trying to complete video #6 in this object ("Connect to Student Data") and I am getting an error when I try to connect to my dataverse tables.

Background:

1. Using Desktop PowerBI

2. Logged into PowerBI with my power up login information

3. Cannot get the tables to load under my name in the Dataverse navigator so I cannot select any data to Load or Transform

DataSource.Error: Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Details:
DataSourceKind=CommonDataService
DataSourcePath=orgcbc47ff0.crm.dynamics.com
Message=A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
ErrorCode=-2146232060
Number=53
Class=20
State=0

Categories:

Miscellaneous

Navigator error.png

I have the same question (1)

All responses (10)

Answers (0)

Suggested answer

w.p 8,339 Super User 2025 Season 2 on at

Like (0)

Report

@LW-18041150-0

can you try to publish all customizations in Power Apps Maker portal.

If this helped, please tick the box to assist others with the same issue in finding this answer too.

Was this reply helpful? Yes No
LW-18041150-0 6 on at

Like (0)

Report

@w.p that did not work for me :(

Was this reply helpful? Yes No
w.p 8,339 Super User 2025 Season 2 on at

Like (0)

Report

@LW-18041150-0

Try reinstalling the latest version.

https://www.microsoft.com/en-us/download/details.aspx?id=58494

Was this reply helpful? Yes No
Suggested answer

w.p 8,339 Super User 2025 Season 2 on at

Like (0)

Report

found some posts:

Solved: Power BI - Unable to locate tables

Error in Loading data by timl

Just to be clear, to connect from Power BI to Dataverse, you don't need a data gateway nor do you need to have named pipes setup.

This is a common problem that Power Up students regularly encounter. The reason is because there's something blocking access to port 1433, which is the TDS endpoint that Dataverse uses.

Usually, this will be a firewall or some other restriction on the network. Therefore, if you're encountering this on a work or school network where such restrictions may be in place, I would try connecting at home or via a phone that's been setup as a hotspot.

Was this reply helpful? Yes No
LW-18041150-0 6 on at

Like (0)

Report

@w.p

I uninstalled my old version, installed the latest version, signed out of my microsoft account and closed the app.

I restarted the app, logged in fresh with my power up login and still seeing the same error.

Was this reply helpful? Yes No
w.p 8,339 Super User 2025 Season 2 on at

Like (0)

Report

@LW-18041150-0

1 - Are you using your work machine?
If so, it’s possible it has been blocked by your IT, as timl suggested.

2 - Have you tried enabling the TDS endpoint in your Power Up Program student environment?
https://learn.microsoft.com/en-us/power-platform/admin/control-tds-settings#enable-user-level-control

Solved: Power BI - Unable to locate tables

Was this reply helpful? Yes No
LW-18041150-0 6 on at

Like (1)

Report

I think there's some filtering going on by my enterprise network team. I have submitted a support ticket to see about whitelisting the connection to the dataverse tables I need for my PowerUp exercises. Thanks for the help!

Was this reply helpful? Yes No
w.p 8,339 Super User 2025 Season 2 on at

Like (0)

Report

@LW-18041150-0

I'd suggest creating a developer environment using your work account—it's free. Or ask your IT to create one for you.

https://learn.microsoft.com/power-platform/developer/create-developer-environment

The Power Up Program student account doesn’t include an Exchange Mail license, so you can’t use the Office 365 Outlook action in Power Automate for sending email. You’ll need to use Gmail or Outlook.com instead.

Your student account will be disabled after the course ends, so you won’t have access to your apps or BI after that.

The Power Up final challenge only requires a video recording submission, so you can build the app anywhere you want.

If this helped, please tick the box to assist others with the same issue in finding this answer too.

Was this reply helpful? Yes No
w.p 8,339 Super User 2025 Season 2 on at

Like (0)

Report

@LW-18041150-0

Just following up on this, if you have any more queries.
For housekeeping, please mark the post, if you have no more queries.

Was this reply helpful? Yes No
CU22040935-0 25 on at

Like (0)

Report

Hello Power Up team,

I am also getting the same error of SQL while connecting to Dataverse table for excerise Video#6

DataSource.Error: Microsoft SQL: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Details:
DataSourceKind=CommonDataService
DataSourcePath=org74952814.crm.dynamics.com
Message=A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
ErrorCode=-2146232060
Number=53
Class=20
State=0
ConnectionId=00000000-0000-0000-0000-000000000000

i have logged in with power up id in power BI desktop App.

pbi error.png

Was this reply helpful? Yes No

Join the conversation

Community site session details

Cannot connect to Dataverse tables

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Microsoft Power Up Program Community

Featured topics

Product updates

Community site session details

Cannot connect to Dataverse tables

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Microsoft Power Up Program Community

Featured topics

Product updates