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

adriansuteu's avatar
adriansuteu
Advocate I
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
9 years ago

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

  • MattAllington's avatar
    MattAllington
    Community Champion
    9 years ago

    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

    • Sean's avatar
      Sean
      Community Champion
      9 years ago

      The latest question here by Anonymous seems to be a Duplicate Post