Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Thank you for help in advance!
Solved! Go to Solution.
There was an issue in the way the gateway was setup. It is working now. Thanks for your input
There was an issue in the way the gateway was setup. It is working now. Thanks for your input
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.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingI 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?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.