Forum Discussion
Connecting data between ServiceNow and PowerBI
The connector is expensive but if you have the budget go for it. API is usually the solution but you'll still need to implement some workarounds as the API has a record limit (and it's also slow). The third option is to generate reports from ServiceNow, e-mail them and set up an automation with Power Automate to pick up those files, upload them into a cloud folder and then importing them into Power BI.
What's the best solution? It depends on the technical knowledge your development team has and the time and cost you want to spend on it.
The connector is expensive but if you have the budget go for it. API is usually the solution but you'll still need to implement some workarounds as the API has a record limit (and it's also slow). The third option is to generate reports from ServiceNow, e-mail them and set up an automation with Power Automate to pick up those files, upload them into a cloud folder and then importing them into Power BI.
What's the best solution? It depends on the technical knowledge your development team has and the time and cost you want to spend on it.
Hi Ray,
Thanks for getting back to me! So with regards to the API work arounds, it is possible to go over the 50k record limit (Even if it does make it slow)?
Furthermore, with the email option is there a limit to the file sizes in the emails? Or can I simply manually upload the first report, then only use incremental updates for the remainder?
Regards,
Kylan
Hi, from what I can recall yes you can bring everything but you need to split the API calls with a function to delimit the number of records thus allowing you to bring everything but in pieces.
For the email option, more than the size of the email is that ServiceNow can't export more than x records for a single file, so you still need to split the reports into multiple files. So getting once the historical records and then using the incremental for the remaining is a good approach.