Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
rajaniesh
Helper II
Helper II

Power BI Gateway setup with ODBC connectivity throwing error

‎07-12-2019 04:20 PM

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

Labels:
Message 1 of 8
895 Views
0
7 REPLIES 7
GilbertQ
Super User
Super User

‎07-14-2019 04:47 PM
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

Message 2 of 8
852 Views
0
rajaniesh
Helper II
Helper II
In response to GilbertQ

‎07-15-2019 07:02 AM

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

Message 3 of 8
846 Views
0
GilbertQ
Super User
Super User
In response to rajaniesh

‎07-15-2019 03:20 PM
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

Message 4 of 8
836 Views
0
rajaniesh
Helper II
Helper II
In response to GilbertQ

‎07-15-2019 07:25 PM

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

 

Regards

Rajaniesh 

Blog

Message 5 of 8
834 Views
0
GilbertQ
Super User
Super User
In response to rajaniesh

‎07-15-2019 07:34 PM

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

Message 6 of 8
831 Views
0
rajaniesh
Helper II
Helper II
In response to GilbertQ

‎07-17-2019 05:36 AM

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

Message 7 of 8
824 Views
0
GilbertQ
Super User
Super User
In response to rajaniesh

‎07-17-2019 03:41 PM
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

Message 8 of 8
804 Views
0

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

View All
Top Solution Authors
View All