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

Unable to set enterprise gateway for ServiceNow (ODBC)

We are using ODBC connection to connect to Servicenow env, I can schedule the reports using personal gateway but unable to select data gateway.

 

 

with continual use of Personal gateway we get below messages:

"The last refresh attempt failed. Your Personal Gateway is offline or could not be reached." as my login on the server where Personal gateway is installed expires.

 

I have installed both Personal and Enterprise gateway on the server.



3 REPLIES 3

Hello @neerav_singh 

In case you're still struggling exporting data from Servicenow, you might want to try out our Servicenow app: Power BI Connector:

We have a handy User and Admin Guides for your convenience, but feel free to reach out support team at support@alpha-serve.com if you need any assistance.

 

Thank you.

Regards,

Anton

===

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-qiuyu-msft
Community Support
Community Support

Hi @neerav_singh,

 

The machine hosts the gateway needs to be access the ODBC DSN. In your scenario, you need to sign in to get gateway work again in the same machine as ODBC DSN created on. 

 

When you use the on-premise data gateway, please use the same connection information as you defined in desktop. By the way, please always keep the gateway to be run as the latest version. 

 

Best Regards,
Qiuyun Yu

 

 

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

The machine hosting gateway has the ODBC DSN created & is working, still the option is greyed out.

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.