web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Power Up Program Community
Answered

Error in Loading data

(2) ShareShare
ReportReport
Posted on by 10
Error is attached below
Categories:
I have the same question (0)
  • Suggested answer
    Michael E. Gernaey Profile Picture
    53,452 Super User 2025 Season 2 on at
    Hi,
     
    The error is pretty clear. 
     
    Either 
     
    1) you do not have a Data Gateway and you need it
    2) you dont have Named Pipes setup as a client connection type in your service (turn it on)
    3) you dont have ports open
     
     
  • Verified answer
    timl Profile Picture
    36,415 Super User 2025 Season 2 on at

    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.
     
     
     
  • w.p Profile Picture
    8,339 Super User 2025 Season 2 on at
  • w.p Profile Picture
    8,339 Super User 2025 Season 2 on at
    For housekeeping and others can benefit, please mark the post if it answers your question.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Microsoft Power Up Program Community

#1
timl Profile Picture

timl 516 Super User 2025 Season 2

#2
mmbr1606 Profile Picture

mmbr1606 62 Super User 2025 Season 2

#3
Michael E. Gernaey Profile Picture

Michael E. Gernaey 55 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Introduce yourself!