Skip to main content

Power BI

Merged

Ability to connect to Perspectives stored in an Excel Power Pivot data model as a dataset OR ability to create perspectives in PowerBI

Vote (25) Share
Stevith's profile image

Stevith on 12 Aug 2015 10:20:07

and then be able to share those datasets.

Using perspectives with PowerBI would be a great way to hide sensitive data and make large data models more manageable.

PowerPivot for Excel is pretty much SSAS anyway right? Would it be possible to use the Analysis Services Connector to connect directly to an Excel PowerPivot Data Model instead? Maybe PowerPivot data models could be exported into a Services Connector readable format?

I'm not a BI Developer, just spitballing here.