Forum Discussion
How to import data into Power BI
Hi All,
I am connecting to ServiceNow system using Rest API, I connect this API to Power BI using WEB connector. Below is how the API looks.
Total numbers of records available are 1,50,000 records but I get the below error when I import the data in Power BI desktop. Can someone please let me know how to resolve this and import the entire data into power bi desktop.
Thanks
Poojitha
4 Replies
- Greg_DecklerCommunity ChampionSeems like perhaps you need to talk to ServiceNow and see if what you are doing is supported.
- AnonymousNot applicable
I am able to pull upto 1,30,000 records after which I get the error mentioned in the question.
- v-kelly-msftCommunity Support
Hi Anonymous ,
Based on your description,it seems an individual issue,better create a support ticket via below link and our relevant personnel will help to handle it.
https://powerbi.microsoft.com/en-us/support/
Best Regards,
KellyDid I answer your question? Mark my post as a solution! - antonstorozhukHelper V
Hello,
The best way to connect Servicenow and Power BI would be to install our app on your Servicenow instance.
Power BI Connector for ServiceNow app:
- https://store.servicenow.com/sn_appstore_store.do#!/store/application/87a42573879e0110fb5033773cbb35...
- https://www.alphaservesp.com/products/servicenow/power-bi/
We have a handy User and Admin Guides for your convenience, but feel free to reach out support team at [email protected] if you need any assistance.
Cheers,
Anton