cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adriansuteu Regular Visitor
Regular Visitor

Import Power Pivot (DataModel) into Power Bi

How am I supposed to import a DataModel into Power BI?

 

I have created a data model and marked it as a Date Table. You can see it in the image below.

 

But after I save it as Excel Workbook, when I try to import this workbook into Power BI, the software only recognizes the empty sheet from the actual workbook, not the data model.

Power-Pivot.jpg

 

1 ACCEPTED SOLUTION

Accepted Solutions
adriansuteu Regular Visitor
Regular Visitor

Re: Import Power Pivot (DataModel) into Power Bi

I figured it out after all.

 

I think that the problem was that I was trying to import the file from Azure as it was (CSV format) in PowerBi.


Solution: I have created a new Query in Excel (Data-New Query), selected that CSV file with the date table and save it after that.

Then I have imported the new Excel format file into PowerBi Smiley Happy


Thanks for your replies,

Adrian

13 REPLIES 13
Super User
Super User

Re: Import Power Pivot (DataModel) into Power Bi

It's on the file menu. From memory, File/Import Data or something like that. 



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Highlighted
waltheed
Advisor

Re: Import Power Pivot (DataModel) into Power Bi

Hi adriansuteu,

 

You should not select Get Data on the start screen, but close the start screen, so that you have an empty pbix file.

 

Then go to File - Import - Excel Workbook Contents, and select your excel file that contains your Power Pivot Model (Excel Data Model).

 

Import from Excel.png

 

 

Then it will create the model inside Power BI Desktop.

It will contain the data and the connections to the source.

 

 

 

 

 

Cheers, Edgar Walther
Power BI User Group Netherlands
Sean Super Contributor
Super Contributor

Re: Import Power Pivot (DataModel) into Power Bi

@adriansuteu If you are looking for your content (pivot tables/charts etc..) - not the Data Model which should be there!

 

Note that only Power View Sheets get imported!

 

So anything not visualized with Power View will NOT be there - you will have to recreate it.

adriansuteu Regular Visitor
Regular Visitor

Re: Import Power Pivot (DataModel) into Power Bi

I figured it out after all.

 

I think that the problem was that I was trying to import the file from Azure as it was (CSV format) in PowerBi.


Solution: I have created a new Query in Excel (Data-New Query), selected that CSV file with the date table and save it after that.

Then I have imported the new Excel format file into PowerBi Smiley Happy


Thanks for your replies,

Adrian

majdya Frequent Visitor
Frequent Visitor

Re: Import Power Pivot (DataModel) into Power Bi

You are life saver

mahimabedi
Advisor

Re: Import Power Pivot (DataModel) into Power Bi

How i can i import a data model for a xlsm file stored on OneDrive? The web connector doesnt seem to bring in the data model and the file> import option only let me select a file onprem locally

Super User
Super User

Re: Import Power Pivot (DataModel) into Power Bi

I know you can't import a data model from na XLSM file to Power BI Desktop. Maybe it is the same here. I simply save the file in XLSX format before importing



* Matt is a Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
Sean Super Contributor
Super Contributor

Re: Import Power Pivot (DataModel) into Power Bi

The latest question here by @mahimabedi seems to be a Duplicate Post

jaygill Frequent Visitor
Frequent Visitor

Re: Import Power Pivot (DataModel) into Power Bi

Hey there!

 

I have a question for you. i've already imported existing power pivot data model in to power BI. 

But i have some done measure and made changes to original power pivot model. Now when i refresh power BI model it's not updating.

 

Can you help? 

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 6 members 1,055 guests
Please welcome our newest community members: