cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Power BI Admin
Power BI Admin

Is there a way to import a model directly into Desktop from an Excel PowerPivot model?

I've been trying to "import" my PowerPivot model from an Excel file directly into Dektop but it looks like the only way of doing this is connecting from service and creating the reports and dashboards there. Is that the case? Thanks!

Data for Everyone! We mean it
10 REPLIES 10
andre
Advisor

Re: Is there a way to import a model directly into Desktop from an Excel PowerPivot model?

the version of the desktop that is currently available for download does not support import from PowerPivot.

Power BI Team AlexGorev
Power BI Team

Re: Is there a way to import a model directly into Desktop from an Excel PowerPivot model?

We are actively working on Excel files import into PBI Desktop! Stay tuned!!!

 

Alex.

sarangan New Member
New Member

Re: Is there a way to import a model directly into Desktop from an Excel PowerPivot model?

I'm trying to follow the support instructions available here:

https://support.powerbi.com/knowledgebase/articles/703422-import-excel-workbooks-into-power-bi-deskt...

 

 

But Power BI Desktop doesn't seem to have this. Is there a timeline for when this feature will be coming through?

Power BI Team AlexGorev
Power BI Team

Re: Is there a way to import a model directly into Desktop from an Excel PowerPivot model?

It is comming VERY soon! Smiley Happy

 

Stay tuned and check http://blogs.msdn.com/powerbi blog for announcements!

 

Thanks,

Alex.

Power BI Team AlexGorev
Power BI Team

Re: Is there a way to import a model directly into Desktop from an Excel PowerPivot model?

Excel Import feature is no available in the August update of the PBI Desktop!

 

http://blogs.msdn.com/b/powerbi/archive/2015/08/20/announcing-the-power-bi-desktop-august-update.asp...

 

Alex.

CLEARIFY Regular Visitor
Regular Visitor

Re: Is there a way to import a model directly into Desktop from an Excel PowerPivot model?

Note that there is an issue if you have renamed your columns inside of the PowerPivot data model. 

 

When PowerBI desktop imports the model, The Advanced Editor is not showing the reference to the actual table name, thus showing an expression error that the column is not found.

let
    Source = Odbc.DataSource("Provider=MSDASQL.1;Persist Security Info=False;Mode=Read;DSN=QQubeUser"),
    #"Renamed Columns" = Table.RenameColumns(Source, {{"Class Active", "Class Active"},{"Class Name", "Class Name"}, {"Class Full Name", "Class Full Name"}, {"LinkForClassID", "LinkForClassID"}})
in
    #"Renamed Columns"

maivarss Frequent Visitor
Frequent Visitor

Re: Is there a way to import a model directly into Desktop from an Excel PowerPivot model?

It's now been 3 months since we would "very soon" be able to import PowerPivot model to PowerBI desktop. Any new on when this will be available? As relationship management seem to work differently in PowerPivot vs. PowerBI desktop (e.g. get some inactive relatonships in Desktop vs. active for the same relationship in PowerPivot), it's currently not possible by uploading the data and editing the relationships directly in PowerBI desktop... Will this also be fixed in a future update? Thanks for an otherwise great tool!!

andre
Advisor

Re: Is there a way to import a model directly into Desktop from an Excel PowerPivot model?

@maivarss you can import Power PIvot model into Power BI Desktop today and should have been able to for a couple of months now.  Please make sure that you have the latest build.  You can also create relationships by draging and dropping just like in Power Pivot.

maivarss Frequent Visitor
Frequent Visitor

Re: Is there a way to import a model directly into Desktop from an Excel PowerPivot model?

@andre thanks for the quick reply - I have Desktop version 2.28.4190.122 which is the latest I find on https://powerbi.microsoft.com/en-us/desktop. When uploading an Excel file with all relationships set up in PowerPivot, I am able to import the data into Desktop but the relationships and calculated measures etc disappears. Then when trying to re-create the relationships in Desktop, some relationships becomes inactive when created whereas they are active in my PoweverPivot model. Any advise on how to resolve this / identify what I'm doing wrong is greatly appreciated Smiley Happy