Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request 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!
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 55 | |
| 24 | |
| 12 | |
| 11 | |
| 11 |