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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

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.