| In Power BI there are a lot of ways to connect to on-premise data sources. However, Power Update from Power ON, offers a different way to scheduling updates on a local computer, and post the updated result to be consumed both on-premise and Power BI/Cloud consumption.Power Update has powerful built in scheduling features that enables you to set it up to run in off-peak hours. Power Update processes the files locally on the network, so no data has to leave the premises in order to update the workbook. Power Update produces, every night, hundreds of thousands of updated spreadsheets with Power Query connections or SQL Server/Oracle connection preparing fresh data in the morning.
Get started with a Free Trial |
 |
Here are the most common scenarios:
Excel to SharePoint
| The most popular method of distributing information today, is to build a Power Pivot Model in Excel, and Publish it to SharePoint on-Premise. |  |
Power BI Desktop to Power BI
| Power BI Desktop is the preferred way to developing a dashboard. PBID has powerful data modeling capabilities, all the standard Power BI Visualizations, and support for the custom visualizations.
PBID does not have the ability to publish to PowerBI.com on a schedule. Power Update does that for you. |
 |
Excel to OneDrive
| OneDrive is a fundamental building block of Power BI. By uploading a Power Pivot workbook to OneDrive, it is easy to connect it to Power BI.
Power Update can be scheduled to update refresh of the Excel Power Pivot model, then publish it to OneDrive. Power BI will as soon as it see the new updated workbook, make the data available for the dashboards in Power BI and dashboards published to web. |
 |
Email Attachment
| Users have unique needs, and some users do not have fast internet connections everywhere. Power Update can attach the Excel Workbook or Power BI Desktop file, and attach it as a XLSX, PBIX or a PDF for easier consumption. |  |
Error Handling
| Power Update’s email feature, can send out status emails on what happened to the job. It is possible to get both “Success” and “Failure” email status notifications that notifies if a connection is down, access rights have changed or other events that will make the update from failing. |  |
