CODEWITHSUNDEEP
powerpivotpowerbi
PeddiePooh
PeddiePooh

Reputation: 403

PowerBI data model conversion

I published my Power BI dashboard to the cloud using Import Excel Workbook Content. Unfortunately my hard disk dies and I lost the original workbook (which contains PowerPivot data model).

Can I convert PBIX file to PowerPivot model? I actually tried to rename the file to .zip and I could see a file called DataModel which has the similar file size as my original model but I don't know what to do with it.

Help me please?

Upvotes: 0

Views: 691

Answers (1)

greggyb
greggyb

Reputation: 3798

Currently the conversion between a Power Pivot for Excel data model and a Power BI data model is one way from Power Pivot for Excel to Power BI.

May I ask why you need to convert back to Power Pivot? Power BI Desktop offers Power Pivot, so you can do your data modelling and measure definition there.

I've seen some people talk about changing the file extension to '.zip', opening up the archive, removing the DATA file, putting that DATA file into a similarly renamed and unzipped Excel document in the 'model' folder, and then rezipping and renaming the Excel file back to '.xlsx'. I've never had luck with this.

Upvotes: 1

Related Questions