powerplanning

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

Power Query is Awesome, but…..

1 Comment

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

image

   
Advertisements

One thought on “Power Query is Awesome, but…..

  1. And Power Update also enables MS SQL / SSAS as the import target for Power Query, it’s no longer a dead end in Excel, you can use it like a fully fledged scheduled ETL solution.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s