Import Power Pivot model to Power BI model

Importing Power Pivot & Power View into Power BI

Import Power Pivot into Power BI

The Power BI August update just rolled out today (8/20/2015) and in the latest update there’s a lot of cool, new enhancements such as writing custom MDX or DAX queries to access your SSAS data sources, connectors for Azure HDInsight Spark and Azure SQL Data Warehouse (so awesome!), some various UI improvements and a bunch more. But one of the coolest features (and much needed IMHO) is that we now have the ability to import Excel artifacts, such as Power Pivot models and Power View reports straight into Power BI Desktop!

New to Power BI Desktop? Read this first!

Import your Power Pivot Model into Power BI

To begin importing a Power Pivot model into your Power BI model, first open Power BI Desktop.

Go to File > Import and then select Excel Workbook Contents.

Navigate to the Excel file that contains the items that you’d like to import. In this case, I’m going to import a Power Pivot model into my Power BI model!

Now you may see a message like what you see below due to the fact that there are certain items that cannot be imported from a Power Pivot model since they’re not yet supported in Power BI.

Here are some of the items that can’t be imported into Power BI:

Import Excel Workbook contents into Power BI

Click Start. Once we click Start, Power BI Desktop will start creating a brand new Power BI semantic model based on the Power Pivot model and Power View items that may exist in our Excel workbook. After the import is complete, you’ll see a summary of the items imported as well as items that were not imported.

Import Excel Workbook contents into Power BI

In our case we can see that a Power View sheet was not imported because it has a live connection to SSAS Tabular. We also have a Profit KPI that was converted to a measure since Power BI does not support KPIs yet.

And our Power Pivot model and Power View reports are now in Power BI! We can see our model:

Power Pivot model imported into Power BI

We can view the data in the tables:

Power Pivot imported to Power BI

And we can see the Power View sheets that were successfully imported:

Power View reports imported to Power BI

Pretty cool!

And now we’re ready to deploy our Power BI model to our Power BI site.

Resources

If you’re new to Power BI or just want an intro, start here.

Here are three Power BI best practices to follow.

Download the August update for Power BI and read about the features included.

What can and can’t be imported into Power BI?

Feedback?

Are you as excited about this Power BI update as I am? I know you are! leave a comment for me and let me know your thoughts!