Power BI

Under Review

Connect to offline/external PowerPivot model

Vote (160)

Jakub Kaczanowski on 08 Jan 2015 12:49:50

I'd like the ability to use the model in an existing excel powerpivot workbook (not uploaded to powerbi) as a data source for PBIDesigner or even directly in the powerbi dashboard. Ideally it would work similar to the connection to an on-premise tabular model. I believe tableau offer functionality to connect to a powerpivot model in an excel workbook

Administrator on 23 Jan 2015 06:14:39

Thanks Jakub, great suggestion! Who else would like this to be prioritized? Please add your votes to help us!

Comments (15)

Comments (15)

Sagar Gurnule on 04 Feb 2024 15:03:57

RE: Connect to offline/external PowerPivot model

Power BI User on 06 Jul 2020 00:10:45

RE: Connect to offline/external PowerPivot model

This is an extremely useful feature! I need to use it to summarise data from various large Excel files, that already house the data and data model.
Unfortunately, now, with no ability yet to use Excel to connect to a Data Model in a different Excel file, this is not yet possible! But something sorely desired!

alex on 05 Jul 2020 23:16:25

RE: Connect to offline/external PowerPivot model

'+1 bump!

David Rose on 05 Jul 2020 22:53:07

RE: Connect to offline/external PowerPivot model

I would want to build my model in one workbook and do the visualizations in more than one other workbooks all off of the same data model.

Anderson on 05 Jul 2020 22:21:45

RE: Connect to offline/external PowerPivot model

As Hassan said before: "I prefer that powerbi desktop connect to the power pivot data model rather than importing it, in this case you can use the in Excel and powerbo dashboard at the same time."

Power BI User on 05 Jul 2020 22:18:10

RE: Connect to offline/external PowerPivot model

Please have this on priority: (Hassan) I prefer that powerbi desktop connect to the power pivot data model rather than importing it, in this case you can use the in Excel and powerbo dashboard at the same time.

Power BI User on 05 Jul 2020 22:17:57

RE: Connect to offline/external PowerPivot model

Is it possible toconnect to the datasource using tableau in offline mode or not?

Hassan on 05 Jul 2020 22:17:19

RE: Connect to offline/external PowerPivot model

I prefer that powerbi desktop connect to the power pivot data model rather than importing it, in this case you can use the in Excel and powerbo dashboard at the same time.

Snehal Patel on 05 Jul 2020 22:12:51

RE: Connect to offline/external PowerPivot model

I would definitly like to have PowerBI as an offline application which can sync with Site or OneDrive

Stevith on 05 Jul 2020 22:03:25

RE: Connect to offline/external PowerPivot model

Could the ability to connect to individual perspectives created in an excel powerpivot workbook be added with this?