Hi, I need to connect PowerBI with ServiceNow tables to prepare reports on PowerBI. Need to understand how to connect these two tools as ServiceNow currently is not available in GetData options of Power BI
Solved! Go to Solution.
Hi @AnandKumar10 ,
I see that it's been a while, and you've already accepted the offered solution, thanks to Community colleagues!
Just in case you ever come to searching for another or additional integration option to fetch data from ServiceNow to Power BI, you can take a look at our app - Power BI Connector. It is available on the ServiceNow Store for a free trial.
All the best,
I am a ServiceNow architect and I don't agree that this is the right approach. Connecting a BI tool directly to a production ServiceNow instance might significantly affect its performance.
For bigger ServiceNow instances with a lot of data, this approach won't work at all because it will take ages to download the data for your report.
There is the best practice of creating a dedicated reporting database containing a copy of the data. Either on-premise DB or an Azure one. And then connecting Power BI to this traditional database. You won't be impacting ServiceNow and the reports will be way faster.
Please use SnowMirror (https://www.snow-mirror.com/) to create such a reporting database.
Thanks but it didn't worked. i tried odbc but its showing below error
Details: "ODBC: ERROR [HY000] [SN][ODBC ServiceNow driver][OpenAccess SDK SQL Engine]Cannot create schema.Cannot retrieve a DB schema. Please run <instance>?SCHEMA in your browser and try again. Also make sure that the table descriptor cache can hold all your tables and DB views. You can check the table descriptor stats runing <instance>/xmlstats.do in your browser."
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.