Best way to connect ServiceNow to Power BI?

[NomisKeem]

Hello all,

I am currently working on a process to connect our ServiceNow instance to Power BI. I wanted to ask about best options and practices. I am considering connecting an ODBC driver to our ServiceNow instance which will then connect to a SQL server database which will connect to the dashboard I have created.

Is this the best way to go about the connection or is there a better way? Also is the SQL database really necessary or will only using the ODBC driver suffice?

Thanks.

[Anna Odrynska]

Hi @NomisKeem 

You can also use Power BI Connector app to integrate the platforms. 

Anna

[Alexander17]

The Power Bi connector is phased out. So that wont work. So long the employee has an ServiceNow user account that have access to the Rest api area, the ServiceNow app in Power BI, should be able to connect to the platform.

[Anna Odrynska]

Hi @Alexander17 

I am not sure which Power BI Connector you're talking about. The one that I mentioned - Power BI Connector app on the ServiceNow Store - is available and working fine 🙂

Anna

[jnoell]

Is this till free? looks like there is a cost for this connector.

[Saperamant]

I recently faced a similar situation while working on a project. I just finished my Power BI training and got certified as a data analyst, so I've been eager to put my skills to use. In my experience, you don't necessarily need a SQL server database in the mix. You can use the ODBC driver to connect ServiceNow directly to Power BI. That being said, having an intermediate SQL database can be useful if you want to manipulate or clean the data before it reaches the dashboard. But if your data is already clean and well-structured, you should be good to go with just the ODBC driver. Hope this helps! Let me know if you have any other questions. Happy dashboarding! 😄