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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.