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[…]

Gantt Chart with Writeback

Modifying GANTT Charts inside Power BI

Power BI continues to Shock and Awe us all, month after month. In the December release of Power BI Desktop, I saw the GANTT chart and we had a use case to update task dates and descriptions on project plans for a client. Background After coming to America 3 years ago and learning DAX through[…]

Game-Changing Planning and Forecasting with Power BI

Q&A/Google – Decomp Tree – Dynamic Measures – Write-Back – Data Point Text Comments Innovation: Power BI keeps innovating. In November 2019 Microsoft released the long awaited Decomposition Tree. This enables companies to analyze, forecast and make predictions to support decision-making inside the organization. Additionally, Visual Planner has since 2015 provided write-back in Power BI.[…]

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[…]

State of the Art Report Writer in Power BI

Historically, BI Systems have lacked Financial Report Writers. Not anymore. Power ON’s Financial Report Writer is built around 4 concepts:          Row Definitions Define the lines and calculations in your report. Take advantage of advanced DAX Formulas or client-side calculations          Column Definitions Users can define QTD, YTD, Monthly, Budget vs Actual, Actuals to Current[…]

Avanade and Power ON

at Microsoft Business Application Summit In today’s blogpost Ed Bobrin, Avanade Executive & Global Lead of Data & AI Center of Excellence, shares his experiences from the Microsoft Business Application Summit 2019. Along with all the AI and Machine Learning solutions that were launched, Ed discusses our Strategic Partnership and Power On’s place in the[…]

Oracle Essbase Hyperion–Writeback in Power BI

Instead of SmartView – Use Power BI Oracle Essbase – Hyperion is holding a 31% market share of a $2.4Bn market for CPM applications according to AppsRunTheWorld. The report is from 2017. Gartner has since then given up using the term CPM as companies are looking to combine BI, Budgeting and Planning in tools like[…]

Power On – Avanade – Power Platform Summit

  Power ON is excited to co-exhibit with Avanade at the Power Platform Summit in Amsterdam from March 27 to March 29. Avanade will demonstrate how Power ON enables write-back and goal-seek to Sales Force forecasting data and Dynamics CRM. Additionally Avanade will present with Power ON how Enterprises can writeback from Power BI to[…]