Skip to main content

Power BI

Needs Votes

Expose Analysis Services perspective

Vote (12) Share
Meagan's profile image

Meagan on 05 Mar 2020 02:06:25

Provide visibility in the Power BI service when a live connection to Analysis Services is connected to a perspective rather than Model.

When we look at settings for a live connection dataset in PowerBI.com, we can see the server and database in the data source credentials, but there is no indication of whether we are connecting to Model or a perspective. If we download the PBIX file, unzip it and look in the Connections file, we can see "CUBE=" in the connection string, but that is the only place to view it. Perspective is not available via the REST APIs either. We need some place to see this if we don't have immediate access to the PBIX file.