Per Solli

The Why Behind the Numbers ‘Why’ is this number what it is? This question is asked a million times a day by anyone doing analysis.

[NOTE: This blog, originally posted in 2017, was updated Oct 2022 to reflect the latest enhancements and functionality supported in Power BI and Power ON.]

The business world is dynamic and ever-changing. With volatile market disruptions, business projections can change at the drop of a dime — posing critical challenges

Businesses the world over use Microsoft Power BI. But leading CIOs, looking to modernize their BI (Business Intelligence) stack, are going beyond visual analysis to

For organizations across the globe, planning and forecasting can be quite challenging. As businesses continue expanding digitally and workflow, people, and data grow and become

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

“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

Planning in a Rut? Corporate Planning and the tools supporting it, is just one of many business processes that have stagnated over time. Today many

Collaborative Planning and Commenting in Power BI: For most companies, forecasting and planning with Microsoft Power BI is a one-way street. Someone pulls together the

It goes without saying that the pandemic shook the business world. With shelter-in-place orders around the globe, virtual meetings instead of physical visits, and shifting relationships

May 4th 2021 will be on of most exciting days for people interested in BI, Analytics, Cloud, Azure, Planning, AI, and Forecasting. If you have

Lechler: How to Drive a BI Evolution with Planning in Power BI How do you enable collaborative planning, maintain data privacy and security, and deliver

TLDR: Many organizations have analysts who tell what happened in the past while some may even get close to predicting what may happen in the

Is Microsoft even further ahead than given credit for in 2021 BI Magic Quadrant? Intro The Gartner Magic Quadrant is a valuable and much anticipated

Power ON Visual Planner Engine Writeback Anywhere Power ON made a strategic choice in 2015 when Microsoft launched Power BI and Azure Analysis Services; to

Power ON is launching Visual Modeler. Power BI requires a data model and business logic(DAX). Traditionally there have been 3 ways to build it: Power

Power ON Visual Planner now supports writeback to Tabular Models inside Power BI Service. Previously Power BI Service was limited to 8 refreshes per day

Webinar – Why Integrated Planning Has Become Essential with CEO of BPM Partners Craig Schiff October 15 @ 1:00 pm – 2:00 pm EDT Why

The “New Normal” will impact how corporations are planning and forecasting business operations. The Hackett Group has put together an analysis and some predictions in

Chris Wade @ Microsoft Power BI Team launched Power BI Premium with XMLA end-point support. Power ON is proud to announce the worlds premiere write-back,

Corporate Innovation – The Future   Every so often, corporations face waves of innovation that is difficult and costly to handle. History has shown that

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.

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

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

at Microsoft Business Application Summit In today’s blogpost Ed Bobrin, Avanade Executive & Global Lead of Data & AI Center of Excellence, shares his experiences

Instead of SmartView – Use Power BI Oracle Essbase – Hyperion is holding a 31% market share of a $2.4Bn market for CPM applications according

  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

   Leading Fortune 500 companies are moving forecasting and planning processes to Power BI. Why? Because now they can! Power BI is gaining adoption quickly,

Power ON is now supporting write-back from Power BI directly to an Oracle DB. The Table Editor custom visual has proven to be a powerful

SSAS Tabular in Azure is gaining widespread adoption in the Power BI community. The best way to currently develop a model for SSAS Azure Tabular

We are proud to announce that our Senior Staff has been invited to participate at the Council on Competitiveness. Power ON realizes that cyber-security is

Early January 2018, Microsoft launched a new custom visual that enables users to enter data in Power BI. Basically, the custom visual opens up a

Budget Once – Forecast Forever Power BI provides unparalleled ability to analyze your data, uncover potentials and reveal problems. Exactly what you need when creating

   Please view the webinar we developed together with our strategic partner, Pragmatic Works.Per Solli presents write-back in Power BI with Matrix, Table Editor, Workflow,

Industrial Strength Data Transfer from Power BI Desktop to SQL Server Power ON is adding support to transfer the data from a Power BI Desktop

SERIOUSLY. Power BI now runs stand-alone on a laptop. Power ON’s Integrated Business Suite is running on localhost, disconnected from the internet. What this means

Microsoft just made available today, what is expected to be the final preview of Power BI Report Server before launch. ”When you buy Power BI

We are proud of the products we make, and when customers unsolicited share their positive experience with us, we want to share them with you

The business landscape is changing more frequently, and so does the need for corporate performance management. Major software vendors have realized this, and built a

Power BI – Visual Planning* Innovates and Disrupts Traditional Corporate Planning Processes! There is a new way to do Corporate Planning. Businesses are currently wasting

In January 2017, Microsoft had a blog post about which visuals were better for displaying Actual versus Budget or Forecast variances. If you liked that

Happy 2017! We are now introducing a new way to get fresh data in your Power BI Desktop Workbooks, and publish them to a Workspace

Power Update is sold by a one-time fee that gives users a perpetual license to use the software forever. Power ON offers an optional maintenance

After purchasign a license, you will receive a license key After downloading and installing the software, you need to activate the software in the Options\Activate

To troubleshoot the update of pbix files using UI Automation, you first need to watch the process and identify the part where the UI automation

To find your license information: Log on to Power-Planner.com If you don’t remember your password, please reset it If you don’t remember your username search

Maintenance covers access to new versions of the software that support newer versions of Windows, Office and SQL Server. If maintenance expired on your license,

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

On the same day we launched Visual Planning for Power BI, FSN – “The Modern Finance Forum”, launched a survey that concluded that organizations not

If you are using Excel 2010 and Power Query datasources Power Update needs to perform UI automation. If UI automation fails for some reason please

If you want to move away form your current over-priced, outdated CPM solutions, Power BI and Power Pivot is here to help. Additionally if you

History For many years the CPM Team (Finance) and BI Team(Operations) has had a tug of war over what data is the best measurement for

At the PASS BA conference in May, Power ON launched Drag and Drop visuals for Power BI on a Surface Tablet. Click on the video

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

Power Planner is the first CPM suite for Power BI. More users are getting used to using touchscreens, and Power Planner now introduces Visual Planning.

If you are using Hyperion Financial Management or Hyperion Planning there is now a simple way to become the Finance Superstar. Hyperion can do all

This week’s Gartner BI and Analytics Summit started off with and interesting bake-off between Tableau, Qlik, Microstrategy and Power BI from Microsoft. Microsoft took an

Backup the files We haven’t added any automated way to backup the settings file in Power Update. If you want to make sure you have

Running PU jobs in a batch file: After you have defined the jobs, you can take even more control over the jobs by i.e. running