Connect Power BI Desktop with ServiceNow

[Anonymous]

Hello,

I would like to connect ServiceNow Data via Power BI Desktop. I tried using a Web-Call via REST Api, but as far as i understand this is not possible as Web Calls in Power BI can only be anonymous, yet ServiceNow needs credentials. I am know trying to connect via ODBC. I do not know if i setup the ODBC Connector wrong or if it is just not working.

Does anyone have experience connecting Power BI and Service Now successfully?

Regards

Dennis

[Pratik_]

Check out this video guide. It helped us.

https://youtu.be/vz2iHuhTAXM?si=h_NgF9PKLu3oNpgZ

[ltopchyi]

Hi @Anonymous 

If this task is still actual for you, feel free to try Power BI Connector . It is a ready solution that allows easy data export from ServiceNow to Power BI. 

BR,

Liuba

[v-yuta-msft · Accepted solution]

@Anonymous ,

You may try the CDATA ODBC driver, for more details, please refer to blog below:

https://www.cdata.com/kb/tech/servicenow-odbc-power-bi.rst

Community Support Team _ Jimmy Tao

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

[dethompson97]

Dennis, 

We had a user connect to Service Now but they instead connected to the SQL Server that contained the data.  I don't know if this is possible for you but I wanted to mention what they did.

Thanks!

Dawn