cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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
Highlighted
Super User III
Super User III

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

Highlighted

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

Highlighted

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

Highlighted

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

 

Regards

Rajaniesh 

Blog

Highlighted

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

Highlighted

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

Highlighted

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors