With Power XL, Business Analysts can now utilize the efficacy of Excel directly inside Power BI. Develop new models in a familiar environment. Publish to the organization for data collections with ease. All spreadsheets are filtered by Power BI and have Write-back for easy collaboration. Any data from Power XL can be shared with all other Custom Visuals. Seamless. It is a no-code solution for
Read MorePower XL: Full Spreadsheet functionality in Power BI
“Excel & Power BI – Better Together” has been the punch line for many presentations. It’s not just a punch line anymore. It’s real. From its inception, Microsoft had a vision for Power BI; that it would be not only a leading Business Intelligence (BI) tool, but a solid collaboration and presentation platform for corporate data. To support their vision, Microsoft enabled partners to develop
Read MoreKick – off Power Update from Microsoft Flow.
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:
Read MoreTroubleshooting 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 during the update process and check for the symptoms below:
Read MoreSome good press about Power Planner
In Paul Turley’s blog post PowerON BI – Write-back to Power BI and SSAS tabular for forecasting and planning I’ve used the Power Update tool from Power On in the past. When I saw the Power Planner demonstrated, the simplicity and ease-of-use just knocked my socks off. The ability to write-back forecast data and report on real-time “what-if” scenarios has been a difficult to
Read More