Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
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
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!