Skip to main content

Power BI

Under Review

Connect to offline/external PowerPivot model

Vote (158) Share
Jakub Kaczanowski's profile image

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 (14)
Jakub Kaczanowski's profile image Profile Picture

fc0a1c4b 3b4f-4cdc-9177-ec90ceee8515 on 05 Jul 2020 22:01:04

RE: Connect to offline/external PowerPivot model

It would be really convenient. Even if it is not tied to Power Pivot and it is only Excel based data. What I like the best of Power BI now is the fact that it is very, very convenient, but I also see the need to make PowerBI a datasource-agnostic service, just like Tableau tries to do.
This would be overkill.

Jakub Kaczanowski's profile image Profile Picture

9c447b0b e619-4b23-b58c-6c81243d5b6c on 05 Jul 2020 21:59:44

RE: Connect to offline/external PowerPivot model

Tableau offers this +1, why Microsoft doesn't support it by default?

Jakub Kaczanowski's profile image Profile Picture

af51c314 8f57-48e9-ab6d-f630f914c1b0 on 05 Jul 2020 21:59:26

RE: Connect to offline/external PowerPivot model

I'd like this, not just for PBIDesigner but also for Excel PowerPivot/PowerQuery. As anonymous said, Tableau offers this.

Jakub Kaczanowski's profile image Profile Picture

8ba951d6 ea86-494a-94c9-b3f1a8043d2c on 05 Jul 2020 21:58:00

RE: Connect to offline/external PowerPivot model

I would like to use the powerbi in offline mode like the tableau desktop and not using the cloud. Hope this would be addressed for enthusiasts like me.