Scheduled data refresh

Power BI reports built with a DirectQuery or Live connection to their data sources execute their queries when the report is accessed by users. For import mode Power BI reports, a Scheduled refresh can be configured from the Manage page, as shown in the following screenshot:

Scheduled refresh of Power BI report 

The Manage page for a report can be accessed via the ellipsis (three dots) of the report icon or via right-clicking. A custom refresh schedule can be configured specific to a given report, or alternatively a shared scheduled can be created in the Site settings menu (Gear icon | Site settings). In the preceding example, the Product Sales Report has been assigned to a shared schedule used by other import mode sales reports.

Given the RAM and CPU resources required to complete the refresh process for large import mode Power BI datasets, separate schedules may be configured to split this workload. Additionally, once the feature is available, a single Power BI dataset should be used as the source for other Power BI reports thus eliminating the need to refresh multiple files.

The refresh schedules created in the Power BI Report Server's web portal are implemented as SQL Server Agent jobs. The properties of these jobs (schedule and owner) can be accessed from SQL Server Management Studio (SSMS). 

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.118.253.223