Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
pvb
Frequent Visitor

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

1 REPLY 1
AbhiSSRS
Solution Sage
Solution Sage

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!

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors