Take advantage of Excel Power Pivot and enable write-back to your data warehouse

1 Comment

PowerBI 2.0 Goes live July 24th 2015 – Power Update Becomes a Strategic Sidekick.

It is a very exciting day tomorrow, July 24th 2015, as Power BI 2.0 goes General Availability(GA). Power Pivot Pro summarized the impact of the event for the Excel / Power Pivot community in this article.

An unanswered question still, is what does this mean for the future of Power Update Next Gen? I will try to provide some insight on this in this blog post:

PowerBI provides Data Connectivity Gateways – both Personal and Data Management. Do I still need Power Update?

The answer is MAYBE. In short the Data Connectivity Gateways are paid features of PowerBI, and if an author of a PowerBI solution starts using a paid feature, ALL users that needs to access the workbook will need a PowerBI license. The PowerBI Free version only supports the date source listed below. So what does this mean for my licensing cost: Well it means $9.99/month=$119/Year per for every user granted access to any Dashboard for PAID features:

Supported data sources for the Power BI Free are:
AppFigures (Beta), Azure Blob store, Azure HD Insight, Azure Marketplace, Azure SQL Database, Azure Table store, Blank query (query that is not accessing any data source),Dynamics CRM Online, Facebook, GitHub (Beta),Google Analytics, Hadoop File (HDFS),OData Feed, Salesforce, Sweet IQ (Beta), Twilio (Beta),QuickBooks Online (Beta),Web, Zendesk (Beta)

As you can see – all a cool set of data sources, but no Data Power Houses like SQL Server, SSAS, Oracle, Postgress, SAP BO or anything else you would be looking for in a real life scenario.


So if you really want access to the most used data sources, you will be left with a $9.99/month=$119/Year per user to access the cool databases in any shape or form with PowerBI 2.0.

PowerBI supports the cool on-premises data sources – but you need to pay $119/User per year.

Power BI currently supports these data source in a Data Management Gateway setup: Access Database, Custom SQL/Native SQL, File based (CSV, XML, Text, Excel, Folder), IBM DB2 Database, MySQL Database, Oracle Database, PostgreSQL Database, SharePoint List, SQL Server Database, Sybase Database, Teradata Database.


SSAS OLAP, SSAS Tabular, SQL Server, and IBM DB2 is support by Power BI as datasourcea, which is very cool, but it as a cost associated with it. (see above)

But wait there is more – Power Query in Excel provides different data sources than PowerBI 2.0 data sources. How does that work?

ODBC, SAP BO, Great Plains, Axapta, Navision, Oracle OBIEE 11. How do I include these data sources in my Power BI solution?


We are now nailing it down to the best features of the PowerBI framework: OneDrive. Power Update supports data refresh of any Data Source that Power Query in Excel supports, including OneDrive, and this is why you might want to consider Power Update for your PowerBI solution.

What should my PowerBI strategy for Data Management look like?

  • If you have on premise, well developed Data Warehouses, make a strategic choice and make your organization invest in Power BI Data Connectors and pay the $119 per user per year. Power Planner is a century long Microsoft Partner.
  • If you are sitting on the fence, there are a few strategies to follow to test out the Power BI 2.0 Free version


  • Power Update makes you refresh ANY data source that Power Query in Excel lets you connect to. (PowerBI does not)
  • Power Update does NOT require another licensing scheme for PowerBI 2.0. Current Pricing is $499 as a one-time fee, and $99 if you want updates to newer versions of Windows. Power Update lets you take full advantage of the entire portfolio.
  • Create a Power BI strategy.
  • Define your Data Sources – Make that lead you to the decision.
  • Adhere to the new Microsoft PowerBI 2.0 solution, as long it follows the Microsoft Roadmap!
  • Microsoft is using Power Update! J Redmond, Israel, Thailand and Singapore….

If you are convinced that Power Update might be right for you and how to make it work with OneDrive and PowerBI 2.0, please read how to make it work from this blog.

Happy BI

The Power Planner Team.



1 Comment

Power Query is Awesome, but…..

With Microsoft’s focus on Business Intelligence in Excel and with Power BI Designer(www.powerbi.com), the most powerful tool in the toolshed that sets PowerBI aside from competition is Power Query.

It can read data from virtually anywhere. From structured data sources like SQL Server, SSAS, Oracle, MySQL, Access, Oracle and DB2 to JSON/Odata, Facebook, SalesForce, CSV, Excel and Active Directory. It can also read whole folders of files, like a hive.

Power Query is more than a query tool, it’s a fully fledged ELT(popular version of ETL) tool. You can Extract, Load then Transform to Power Pivot, and even to a SQL Server with an Excel Add-in. This is extremely powerful in enabling self service BI.

However, there is no way to schedule Power Query in an efficient way; you currently have to manually kick off the jobs.

But Wait – There is a solution!!! Power Update from the PowerPivotPro team enables you to schedule Power Query Excel Workbooks. Download a free version of this popular tool.

This blog article from Rob Collie explains how it works.

Check it out.

Excel – Power Query and Power Update



Automate refresh and uploading files to OneDrive and SharePoint and Power BI

Free Trial Excel is a great tool for sharing data with coworkers. However, keeping these spreadsheets up to date is tedious and cumbersome, especially if the are connected to Oracle, SQL Server, MySQL or any type of external data source.

Now, Power Update is your Excel Butler, that works rentlessly of keeping these spreadsheets up to date no matter where they are stored. Power Update downloads the workbook, refreshes all data connections and re-uploads them to:

* OneDrive (private or business)
* SharePoint On-Premise
* Office 365
* Google Drive
* Power BI

Get started today

Register for a 30 day free trial.

Power Update Completes the Power BI Stack

Hi All,
If you are excited about Power Pivot and the announcements Microsoft made last week about Power BI, the introduction of Power Update will make your job even easier and enable updates of Power Pivot models no matter where you publish them. Read more about Rob Collie’s review of Power Update… 


Leave a comment

Power Pivot Update

Power Planner is proud to introduce Power Pivot Update. Main features are:

  • Refresh Power Pivot workbooks
  • Refresh SSAS Tabular models
  • Refresh SharePoint on-premise workbooks

While you sleep.

Schedule at any interval down to every 5 minutes.


Supports local, SharePoint, on-Premise, o365 and SSAS Tabular Power Pivot models.


Power Pivot Update runs all your Power Query or Power Pivot connections in your workbook.

For Office 365 Microsoft offers Data Management Gateway for refreshing data.
Power Planner has now made it available on any source, local, SharePoint on-Premise and SSAS tabular.

Read more on our product page.

Leave a comment

Edit SQL Tables in Excel

Add new members on the fly.

In the Power Planner Ribbon, you can open any SQL table, edit the members, add new products on the fly, and reprocess the model.


  • Just click ‘Open’


Select the table to edit. New members are automatically added to the Budget model.


Click Insert Row, and Save the table and the model is regenerated.


Enable write-back on any Pivot Table with Power Plannner

Any Pivot Table you can now turn into a Budgeting, Forecasting or Planning solution!

    Get Started:

  • Install Power Planner
  • Enable Cell Editing in the Pivot Table
  • Budget and Forecast on any new or existing model


Enjoy Features:

– Multi User Budgeting and Forecasting Features

– Goal Seeking on any number

– Even and Seasonal Allocations

– Revenue Forecasting

– HR Budgeting

– Capital Expenditure

– Driver based planning

– Collaboration and commenting

Go to our website for more information.