Forum Discussion
Import Power Pivot (DataModel) into Power Bi
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
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.
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
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
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
The latest question here by Anonymous seems to be a Duplicate Post
