Skip to main content
Microsoft Idea

Power BI

Planned

Support for importing from PowerPivots shared on O365 or SharePoint

Vote (266) Share
Christian Berg's profile image

Christian Berg on 15 Jan 2015 15:25:28

Importing from Excel currently does not seem to support PowerPivot and requires a local path to the file.

Administrator on 23 Jan 2015 06:54:14

Hi Christian. We're planning to provide the ability to connect to and/or import an existing PowerPivot model into the Power BI Designer and to the Power BI service. If anyone else thinks we should prioritize this please add your votes!

Comments (5)
Christian Berg's profile image Profile Picture

Power BI User on 05 Jul 2020 22:05:35

RE: Support for importing from PowerPivots shared on O365 or SharePoint

Yes, yes, yes! I have a complex PowerPivot data model with a few hundred measures. Don't want to recreate the whole thing over again.

Christian Berg's profile image Profile Picture

Dan on 05 Jul 2020 22:01:55

RE: Support for importing from PowerPivots shared on O365 or SharePoint

Hello, Please definitely priorize this. I'm just setting up our BigData for several companies in the Heat&Power-Segment. Most of our data for number chrunching is used in existing PPivot-Models. We want to use Power BI to web enable with PowerPivot tabels/models. And we need this solution asap.

Christian Berg's profile image Profile Picture

Power BI User on 05 Jul 2020 22:01:09

RE: Support for importing from PowerPivots shared on O365 or SharePoint

definitely required. Right now Tableau can connect to a Power Pivot model how come Power Bi can't. Microsoft is loosing clients & business because of this. Right now I have a large project which uses a Power Pivot data model to do the number crunching for operational KPI monitoring for 6 billion dollar plants. I want to use Power BI to web enable - it looks like a perfect solution- but have to now consider other options

Christian Berg's profile image Profile Picture

Stephen Thomas on 05 Jul 2020 22:01:04

RE: Support for importing from PowerPivots shared on O365 or SharePoint

Yes - Please up this on your list. This would drastically save time on reports already created. I am working on a project and everything is built with PowerPivot and this kind of an issue given certain limitations with security and see that the Azure Data Warehouse is not yet released to the public this is becoming more and more needed.

Christian Berg's profile image Profile Picture

Power BI User on 05 Jul 2020 21:57:34

RE: Support for importing from PowerPivots shared on O365 or SharePoint

Yes Please.