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

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Is there a way to do it vice versa, as in importing data models and relationships built in Power BI into Microsoft Excel ? 

MattAllington's avatar
MattAllington
Community Champion
7 years ago

No, it only goes the other way. But you can publish the PBI to powerbi.com and use Analyze in Excel (with a pro account) or you could use my local host workbook technique to do a similar thing on your pc. Analyze In Excel Without PowerBi.com