Forum Discussion

adriansuteu's avatar
adriansuteu
Advocate I
10 years ago
Solved

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, whe...
Need Help
Tutorial Requests
  • adriansuteu's avatar
    adriansuteu
    10 years ago

    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 :smileyhappy:


    Thanks for your replies,

    Adrian

waltheed's avatar
waltheed
Impactful Individual
10 years ago

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).

 

 

 

Then it will create the model inside Power BI Desktop.

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

 

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Does PowerBI refresh the data from the data source as needed? Or does data become static in PowerBI freezing to reflect the version in effect the moment you import it from PowerPivot?