Forum Discussion

pvb's avatar
pvb
Frequent Visitor
4 years ago

Live Connection to Tabular Model with technical user

Hi all,

 

is it possible to connect to an on-prem tabular model using Live Connection but through a technical user rather than the currently signed-in user?

 

We currently have a tabular model running on an on-prem SSAS instance which we currently do not want the users to directly access using excel or PBI, however, there is this one PBI report which uses a live connection to said model and which should be accessible to the users. Our idea is to use as technical user to connect to the model rather than the user's credentials and basically not grant access to the cube for the individual users. Unfortunately, switching to import is not an option at the moment and we can also not restrict access to the SSAS instance on network level as there are other tabular models running on the same instance which should be accessible by the users.

 

thanks

Need Help

1 Reply

  • AbhiSSRS's avatar
    AbhiSSRS
    Solution Sage
    4 years ago

    The issue with Live is that you do need to grant access on the cube in order for the end user to be able to see data on the report. Basically in Live everything that controls the report (model/security) is in the cube and thus the report cant control access on its own. I wish someone can put up a workaround here on the forum but haven't been able to get across this due to the way this works!