Forum Discussion

SM_1997_'s avatar
SM_1997_
Frequent Visitor
4 years ago
Solved

Connect ServiceNow to Power BI

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.

Need Help
Tutorial Requests
  • SM_1997_'s avatar
    SM_1997_
    4 years ago

    Oh oops I just realized, It'll be like: ServiceNow Instance > ODBC Driver > SQL > Power BI

7 Replies

  • Syndicate_Admin's avatar
    Syndicate_Admin
    Administrator
    3 years ago

    Hello @Syndicate_Admin

    You might want to try an alternative solution? We've built an app for Servicenow and Power BI integration: Power BI Connector for Servicenow. It's easy to use, it's fast and automated. Feel free to DM me in you want to Trial it or need any assistance.

    Cheers!

    Anton

    ===

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

    • Mary_aj's avatar
      Mary_aj
      Frequent Visitor
      1 year ago

      Please tell me if this will work with the Power BI Server.

  • aj1973's avatar
    aj1973
    Community Champion
    4 years ago

    Hi SM_1997_ 

    It could work, but why you don't connect directly to SQL server without ODBC?

    • SM_1997_'s avatar
      SM_1997_
      Frequent Visitor
      4 years ago

      How would I go about that? Is there a chance it could hurt the performance?

      • aj1973's avatar
        aj1973
        Community Champion
        4 years ago

        SM_1997_ 

         

        The performance of a report doesn't rely on the mode of connection to the source.