Kick – off Power Update from Microsoft Flow.

New to Power Update? Power Update has since 2015 assisted companies with automating Power Queries in Excel or in Power BI Desktop. When comparing Power Update and Power BI Service refresh, our clients are mentioning: No limits per day. Processing happens on the client side. Start a job down to every 1 minute Refresh Power[…]

Build Secure Data Collection Apps in 1-2-3.

Power BI is an amazing reporting and dashboarding solution that everybody is talking about. With Visual Planning/Visual Modeler from Power ON, you can now develop Power BI Apps that is used for data collection. We have created a product sheet for Visual Modeler. Use cases Sales Forecasts, Inventory Management, Salaries and Benefits, Variance Reporting, Assets[…]

Troubleshooting Excel PowerPivot Update

If you are using Excel 2010 and Power Query and have an issue during UI Automation, or if the task succeeds but the data doesn’t update please refer to the related article Otherwise please check the error messages in the C:\Users\[USER]\AppData\Local\Temp\PU.log file and turn on Options\Diagnostic Mode to see if Excel displays any popup messages[…]