Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
rajaniesh
Helper II
Helper II

Power BI Gateway setup with ODBC connectivity throwing error

Hi, 

 

I have successfully setup a PowerBI Gateway VM in onPremise environment and setup System DSN with ODBC connectivity to DB2. I have tested it and it is working fine when I connect PowerBI Desktop on the Gateway Machine and connect to the DB2 Datasource. 

Now when I use the same setting at gateway level I found this error:

 

 

 

Powerbi Not Authorized Exception.jpg

 

Any clue!!

 

Regards

Rajaniesh

7 REPLIES 7
GilbertQ
Super User
Super User

It would appear that you cannot authenticate against your data source.

I would double check with the database owner that the user account is still working and active?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

How to debug this issue because I am able to connect to the Db2 by Powerbi Desktop but when I try to connect from PowerBI Gateway it throws the error I pasted.

 

Regards
Rajaniesh

Hi there

Can you confirm from your Power BI Administrator that you can install and configure data sources in the Gateway?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Yes I can install the gateway and I have installed the Gateway and it is showing it online.

 

Regards

Rajaniesh 

Blog

Hi there

 

Can you have a look at the logs when you try and create the connection and see what the error is?

 

Also is the ODBC driver installed on the Gateway Server?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Yes ODBC driver is installed and Power BI  Desktop is connecting by using ODBC driver.

I would recommend having a look at the Gateway Logging and see what it causing the error..

There would be more details in the gateway logs.




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors