Skip to main content

Power BI

Planned

Support for importing from PowerPivots shared on O365 or SharePoint

Vote (265) 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

015b74af 9a64-447e-bf15-056c40f1480b 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

01738942 7510-4511-94e8-64e2c46717e4 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

fd0cce06 9ecf-4abb-a46c-cadd35cab577 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

a774875d 8375-4cec-9265-9719d4eabf0a 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

dc011f60 c64a-4280-a44e-619fcfce846f on 05 Jul 2020 21:57:34

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

Yes Please.