cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
harishreddys
Frequent Visitor

Data Gateway : Unexpected Error

When I try accessing a SQL Database through on-premise data gateway using Data Flows, I get an Unexpected Error with a session ID. 

 

I am not able to access this database via Power BI desktop too. 

 

Check the picture for more details. 

 

Another collegue of mine who setup the on-premise gateway is able to access without any issues. Is there a reason why I am getting this specific error?

 

Annotation 2020-01-21 194220.png

 

Thank you for help in advance! 

1 ACCEPTED SOLUTION
harishreddys
Frequent Visitor

There was an issue in the way the gateway was setup. It is working now. Thanks for your input

View solution in original post

3 REPLIES 3
harishreddys
Frequent Visitor

There was an issue in the way the gateway was setup. It is working now. Thanks for your input

View solution in original post

edhans
Super User III
Super User III

You have a permission or database configuration issue locally. Never try to set up a gateway if you cannot get your desktop to connect. It just won't work. Get with your IT department to assist to get your local desktop app to work, then proceed to the gateway.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
Stachu
Community Champion
Community Champion

I would start with trying to make it work on Desktop first.

I don't expect your colleague set up the gateway in the personal mode, correct? Do you use same authentication as your colleague?



Did I answer your question? Mark my post as a solution!
Thank you for the kudos 🙂

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors