Forum Discussion
adriansuteu
10 years agoAdvocate I
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...
- 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
MattAllington
10 years agoCommunity Champion
It's on the file menu. From memory, File/Import Data or something like that.