Hi Guys, How to specify a prespective within an on premise data source (tabular cube) configred on power bi service ? I can conenct to the on primse tabular cube but I can't seem to workout where to specify the prespective I have on the tabular cube. any help would be appriciated. Thanks.

MattAllington I was thinking the same thing, but with option 2 - this still gives the end user access to potentially get access to the entire model. Because, presumably, the Service data source would be to the model (as it can't be to the perspective). So all the end user would need to do is change the desktop connection to the model and publish. (hypathetically...)This also brings up another question in my mind. If the Desktop treats the perspective as a seperate data source... does this even work in the Service since the approved data source is pointed at the model?.. Doesn't seem to align with how things are set up.

Well the Service definitely presents the perspective to the user, but I also believe the user has the potential to get to the entire model (which is why I suggested row level security earlier). But if access to additional columns is a security issue too, then that is a different (and I believe unsolvablve at this time ) issue. There is no issue with users publishing the desktop model, as they must be administrators of the Gateway to be able to do this. So in this use case, you would not want to give them admin rights to the gateway, and it is also not needed because once the model is published once, it doesn't need to be published again to do what the OP wanted. However there is still no backup, and that is why I never build any meaningful content in the service

You don't specify it in the gateway. Create your workbook in Power BI Desktop connected to SSAS. Before you publish it to Power BI, You can edit the cube and the perspective using "edit connections". Each time you republish, you can select a different cube and/or perspective if you like

Thanks for yout reply Matt. However we need to give access to some users in power bi service and they will create reoport there in service report editor in browser not from their desktop, and we wanted to have these users restrictive access the some attributes in the cubes diemnsion, so we created a prespective but it doesn't seem like while creating a data source in gateway we can specify a precpective. Is this true ? or do we have a way to specify this in gateway ? thanks

I have never seen a perspective connection in the gateway, only the way I described above. Also note that the perspective doesn't lock down the cube. Have you considered role/row level security instead? This will work without he need for perspectives.

gateway data source to ssas tabular prespective

11 Replies

MattAllington
Community Champion
10 years ago
You don't specify it in the gateway. Create your workbook in Power BI Desktop connected to SSAS. Before you publish it to Power BI, You can edit the cube and the perspective using "edit connections". Each time you republish, you can select a different cube and/or perspective if you like
- Anonymous
  Not applicable
  10 years ago
  Thanks for yout reply Matt. However we need to give access to some users in power bi service and they will create reoport there in service report editor in browser not from their desktop, and we wanted to have these users restrictive access the some attributes in the cubes diemnsion, so we created a prespective but it doesn't seem like while creating a data source in gateway we can specify a precpective.
  
  Is this true ? or do we have a way to specify this in gateway ?
  
  thanks
  - MattAllington
    Community Champion
    10 years ago
    I have never seen a perspective connection in the gateway, only the way I described above. Also note that the perspective doesn't lock down the cube. Have you considered role/row level security instead? This will work without he need for perspectives.

Forum Discussion

gateway data source to ssas tabular prespective

11 Replies

Related content

OnPremise GateWay error

Gateway powerBI

Process Tabular model

Tabular measure.

Gateway Restart Script For Gateway Offline