skip to Main Content

Power BI Desktop Now Converts Power Pivot Workbooks

Post by Rob Collie


Another Excellent Step:  Power BI Desktop Now Converts Excel Power Pivot Workbooks

Download the Latest Version of Desktop and Try It

I know, I know.  I’ve been talking about Power BI Desktop a lot lately. But to be fair, I had written NOTHING about it until very recently, so there was a backlog of sorts to be cleared.  I feel like that “behind-ness” has now been adequately addressed by posts here and here, with additional posts here and here by Avi and Andrew, respectively.

But now, they’ve added something significant that you likely find quite interesting:  you can take your existing Power Pivot workbooks and convert them to Power BI Desktop (PBIX) files.

Download the Latest Power BI Desktop

Brings in Data Sources, DAX, Relationships, Queries, Power View…

Read the Rest

Power BI Designer vs. Excel: What’s Microsoft Up To?

Post by Rob Collie

Power BI Designer:  A Good Thing for the Power Pivot Revolutionary in Your Life

This is Power BI Designer, a New Product from Microsoft, and It’s Relevant to ALL of Us.

Major Seismic Activity out of “Mount Redmond”

Some of you may have seen it already, but just in case you haven’t:  in recent months, Microsoft has been touting a preview of what it calls Power BI Designer.  You can download it here for free, and install it right next to all of your other tools, TODAY.

I’ve held off, a LONG time, in writing about Designer.  Because I wasn’t yet sure what to make of it.  I’ve been wary of it, critical of its existence.  It’s taken many, MANY off-the-record conversations with my former colleagues at Microsoft, and a lot of reflection, but now I am ready to talk about it, and even endorse it – with a few caveats near the very end of this post.

The Many Desktop Applications of Power BI

My Start Menu is Getting Crowded with Data Tools:
Excel 2010, Excel 2013, Power BI Designer, and Power Update

Designer is Clearly…  Familiar to Us

Once you install it, you immediately start noticing some similarities to things we know and love:

Power BI Designer Basically Contains Power Query, It's Just Not Called That

Same Basic List of Data Sources We See in Power Query

And then the ribbon has some old friends for us as well…

Read the Rest