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

jaygill's avatar
jaygill
Frequent Visitor
8 years ago

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? 

MRussett's avatar
MRussett
Advocate I
8 years ago

I am also curious about this.  My organization generates monthly power pivot reports that come from various databases I do not have direct access too.   However I can download the XLSX and import the data structure into PowerBI really nicely.   It would be nice if I could download the new report each month and update my PowerBI... however re-importing erases all the customizations I have made in PBI