Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Oh oops I just realized, It'll be like: ServiceNow Instance > ODBC Driver > SQL > Power BI
This video guide is what I referred to set it up for my team
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.
Hi @SM_1997_
It could work, but why you don't connect directly to SQL server without ODBC?
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
How would I go about that? Is there a chance it could hurt the performance?
The performance of a report doesn't rely on the mode of connection to the source.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Oh oops I just realized, It'll be like: ServiceNow Instance > ODBC Driver > SQL > Power BI
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
102 | |
86 | |
77 | |
69 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |