Power Query In Servicenow

[tksnota01]

Hi,

I want extract data from Servicenow on daily basis instead of weekly data dump.

Is it possible to use the API to extract the excel sheet daily? If so, how do I get the daily refreshed data to feed my PowerBI

Thanks...tksnota01

BTW. I'm an old member of the forum using tksnota but moved to a different company. Is it ok to move all my old messages to this new account

[tksnota01]

Hi,

I'm very new with the api.

How do I get the Rest API from Service Now?

Thanks...tksnota01

[v-sgandrathi · Accepted solution]

Hi @tksnota01,
Thankyou for using Microsoft Community Forum.

Yes, you can use the ServiceNow API to extract data daily. ServiceNow provides a REST API to pull records from different tables. You can set up a scheduled task to call the API every day to retrieve the data you need. After that, you can write a script to export the data in a format like CSV or Excel. To automate the process, you can use Power Automate or any task scheduler to run the script daily and upload the data to Power BI. This will ensure your data is refreshed and available in Power BI every day.

Once you have the data in Excel, you can automate the process of refreshing data in Power BI by using the Power BI Service. Power BI allows for scheduled refreshes, so you can configure Power BI to refresh the dataset at regular intervals. You’ll need to make sure your Excel file is hosted in a cloud location that Power BI can access.

Unfortunately, forum accounts are typically tied to a specific user, and messages from previous accounts usually cannot be transferred to a new one. However, you can reach out to the forum administrators or support team to see if there's any possibility of merging accounts or retaining your old messages.

Glad I could assist! If this answer helped resolve your issue, please mark it as Accept as Solution and give us Kudos to guide others facing the same concern.

Regards,
Sahasra.