Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Power BI Premium Dataset Perspectives Ignored within Service Portal while viewing/editing Report

Submitted by Anonymous on ‎02-04-2021 12:19 PM

Note: we have opened a Premier Support ticket for this issue, but would like to post it here for visibilty and hopeful escalation by the Product Group.

 

Power BI Premium Dataset Perspectives are ignored within the Service Portal while viewing/editing a Report, published from Power BI Desktop into a Premium Workspace, pointing to a Premium Dataset containing Perspectives.

 

The Perspectives are confirmed as functioning while connecting from Power BI Desktop to the Power BI Premium Workspace Dataset.


This does not align with feature parity as per a Principal Program Manager on the Power BI CAT team.

 

Please note - we have tried enabling Personalize Visuals - which *does* succesfully limit the list of tables available when in READER mode to the Perspective, but as soon as a user goes into EDIT mode, the entire model is visible once again.  You might say this is expected behavior, BUT within Power BI Desktop, while building a report, against a Perspective of a PBI Dataset, exposed through the XMLA endpoint, the user is NOT able to expand outside of the Perspective and is properly limited to the tables and columns within said perspective.

Status: New
See more ideas labeled with:
2 Comments (2 New)
Comments
v-chuncz-msft
Community Support
Community Support
‎02-05-2021 01:05 AM

@Anonymous 

 

Thanks for your update. We understand that the issue may be urgent and you have created a support ticket. Hopefully, it could be resolved soon and it would be great if you could share the solution to help more users.

dbeavon3
Continued Contributor
Continued Contributor
‎07-21-2023 09:24 AM

I agree that Power BI report development needs a better experience that takes perspectives into account

 

Some of our measures will only be calculated properly against a subset of related tables.   If the proper perspective isn't used (limiting related tables) then the measures could be added to a report in a way that generates misleading or meaningless numbers.

 

Perspectives need to be used to limit the available tables for report builders, (in addition to report users).  The "personalize visuals" experience is insufficient since it doesn't apply to report builders.

 

 

Idea Statuses