Forum Discussion
Perspective in a Tabular Model recently broken for anyone else?
I've been happily using PowerBI connected to a large tabular model with a few perspectives, and just noticed that the perspectives feature seems to be broken in PowerBI. It definitely WAS working, but now it ain't.
Here's my situation; I have an on-premise tabular model in SSAS with ~5 perspectives. If I connect to the model from Excel using PowerPivot and select a perspective, then only those objects in the perpective are available to me. If however I use PowerBI and choose the same perspective, I see ALL the objects for the complete model.
Has anyone else seen this? Or not? I really need perspectives to work, because my model is so complex that end users need to see only their own area.
I see. If you are using the SSAS connector with the powerbi.com Service, it is likely the same or a similar issue to what I have.
In my case, if I have a dataset using one perspective, and then setup a second connection using a different perspective, the initial dataset changes to reflect the second perspective. Further complicating things, we are using group workspaces where many groups have a perspective targeted toward them. When a dataset in one group "flips" to a different perspective, existing queries still appear to run properly, but attempting to browse and create a new report is a problem. Users can see parts of the model not targeted toward their group's perspective. We are employing row-level security in the tabular model though, so our workaround is simply to use the main model and avoid perspectives for the moment.
5 Replies
- deldersveld
Resident Rockstar
Perspectives are working fine for me on-premises (SSAS connector in Service is a different story). Assume you are using the latest version of PBI Desktop and have a live connection to the tabular model?
I'm using the Web site, powerbi.microsoft.com, not the desktop version.
Actually I suspect that the engineers over at MS are fiddling with stuff, because at one point yesterday evening I was finding that all of the perspectives were showing the same set of the tables as one of the more restrictive perspectives. This morning, that problem is fixed, and I'm back to all the perspectives showing the same (complete) set of tables.
- deldersveld
I see. If you are using the SSAS connector with the powerbi.com Service, it is likely the same or a similar issue to what I have.
In my case, if I have a dataset using one perspective, and then setup a second connection using a different perspective, the initial dataset changes to reflect the second perspective. Further complicating things, we are using group workspaces where many groups have a perspective targeted toward them. When a dataset in one group "flips" to a different perspective, existing queries still appear to run properly, but attempting to browse and create a new report is a problem. Users can see parts of the model not targeted toward their group's perspective. We are employing row-level security in the tabular model though, so our workaround is simply to use the main model and avoid perspectives for the moment.
