Users can publish ServiceNow Power BI reports and dashboards in Power BI Server or Power BI Service.
The Power BI reports and dashboards won’t refresh by default.
To get actual ServiceNow data in the reports and dashboards in Power BI, a few options exist:
users can apply a refresh manually on a regular basis;
users can schedule a refresh to a suitable time;
users can create on-demand refreshes.
Scheduled Refresh is the scheduling task that can be set for data extract refresh. Thus, users get refreshed automatically while publishing a report and dashboard with this data extract.
This also removes the burden of republishing the reports and dashboards every time the concerned data gets updated.
With Power BI Connector for ServiceNow, you can schedule refreshes to get the actual ServiceNow data. For example, you can schedule a refresh for 7 a.m. and have all your reports updated with actual ServiceNow data until the beginning of your working day at 9 a.m. See instructions below.
Note! It is impossible to get live ServiceNow data in Power BI and have a real-time synchronization.
Based on the Microsoft manuals, only a few data sources allow streaming live and real-time data in Power BI at the moment. Based on our customers' best practices, we kindly recommend using a scheduled refresh to get actual ServiceNow reports in Power BI.