|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: