Allow Power BI Desktop to Create Perspectives (Similar to Power Pivot, SSAS)

RE: Allow Power BI Desktop to Create Perspectives (Similar to Power Pivot, SSAS)

Good information, thanks

sehackear.top

RE: Allow Power BI Desktop to Create Perspectives (Similar to Power Pivot, SSAS)

Thanks

Hackear Instagram

Hackear WhatsApp

Hackear Facebook

RE: Allow Power BI Desktop to Create Perspectives (Similar to Power Pivot, SSAS)

Hi,

Tabular Editor can add "Perspectives" on an existing Semantic Model.

When using Power BI Desktop, the idea is to add a combo box in the Data panel. The combo box will contains all defined perspectives.

Thus, user can understand the dimensional matrix and avoid tu use measures or dimensions in bad context.

Regards,

Denis

RE: Allow Power BI Desktop to Create Perspectives (Similar to Power Pivot, SSAS)

This is THE feature from Analysis Services which is missing to make Enterprise models/datasets more usable in Power BI. It really is the only feature which I can talk with end users or others about which I could recommend Analysis Services over Power BI for enterprise models. Get perspectives fully implemented in Power BI!!

RE: Allow Power BI Desktop to Create Perspectives (Similar to Power Pivot, SSAS)

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.

RE: Allow Power BI Desktop to Create Perspectives (Similar to Power Pivot, SSAS)

The new modeling view in Power BI Desktop supports multiple layouts and many features (multi-select) that make designing large models easier. Perspectives should be added to the new modeling view with a 'Manage Perspectives' icon next to the Manage Relationships and Manage Roles icons on the Modeling tab.

In an initial release, the Manage Perspectives dialog should provide the same features as what's available to Analysis Services projects in Visual Studio. For instance, there should be a table with each column representing a distinct perspective and the modeler can quickly choose which tables and individual measures and columns are included or not in a given perspective. Additionally, also like Analysis Services, the modeler should be able to view/evaluate and toggle between the different perspectives to view the user experience.

RE: Allow Power BI Desktop to Create Perspectives (Similar to Power Pivot, SSAS)

Great idea! Waiting for this

RE: Allow Power BI Desktop to Create Perspectives (Similar to Power Pivot, SSAS)

Thanks for all the great improvements, we are finally switching over.

I agree with the need for this, this will save us from having to have a version of each of our reports so we should be able to dramatically reduce our report count if we can get this.

We are a shop that uses PBI embedded is is possible to pass the perspective into an embedded report since we know which perspective our user would want to start with?

Thanks again.

RE: Allow Power BI Desktop to Create Perspectives (Similar to Power Pivot, SSAS)

This was always available in Power Pivot as far as I can remember. It seems we took a step back with Power BI, since this feature was dropped :-(

Would certainly be very useful.

RE: Allow Power BI Desktop to Create Perspectives (Similar to Power Pivot, SSAS)

I totally agree that it would be very welcome to view, manage and maintain perspectives in the model view of Power BI Desktop. Especially since perspectives are now also used for visual personalization purposes.

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-august-2020-feature-summary/#_Perspectives