Can i open on premise data in .pbix file in Excel

[richlyn]

Hi All,

I have saved data in a pbix file in power BI and want to work on this data (import it in) in Excel.

Can this be done and how.

[BhaveshPatel · Accepted solution]

You can not import the PowerBI data into the Excel. You can export the data from powerbi visuals and can create a new data model in powerpivot Excel or adhoc analysis. 

You can also upload your powerbi file to Service and use Analyze in Excel feature to browse the cube but data modifications are not allowed in that case.

[ImkeF · Accepted solution]

Yes, there are limitations to the methods officially supported. But there are workarounds:

If you just want to access the data as it is and build pivot-tables or charts on it, this method would be easiest:

http://exceleratorbi.com.au/excel-workbook-connection-local-power-bi-desktop/

But if you want to crunch the data further before creating your reports, you can also import the content of the pbix-file (incl. measures!) into Power Query in Excel, using the function that you find in this article:

http://www.thebiccountant.com/2016/11/15/incremental-load-powerbi/#more-1382

Pls let me know if you need any help implementing this.

[BhaveshPatel · Accepted solution]

You can not import the PowerBI data into the Excel. You can export the data from powerbi visuals and can create a new data model in powerpivot Excel or adhoc analysis. 

You can also upload your powerbi file to Service and use Analyze in Excel feature to browse the cube but data modifications are not allowed in that case.