Forum Discussion
Helper VC# XMLA TOM Connection Failing
v-sgandrathi GilbertQ I appreciate the back and forth you've provided. I have been unable to get the Tabular Object Model to work. However, I have found a way using the ADOMD connection to get the datasource names that includes the actual table or view named used in each Power BI report and this helps.
Again thank you for your time. I may revisit this as I'd like to figure out how to get TOM to work. I'm not sure if it's my .Net Framework, if it needs Core or something else.
Helper Vv-sgandrathi Thank you for your reply. I read somewhere today that Premium Per User workspaces cannot use a service principal. So, I tried to do it with an interactive token but I still get the same invalid connection string error.
When I go to the Application API permissions, I only see two entries.
So, this led me down to make sure I have other items set up correctly and screenshots are below:
XMLA Endpoint:
Service Principal permissions - all set with a security group that the service principal is a member of:
Am I missing something else?
Super UserPPU workspaces can use Service Principals. All workspaces can use Service Principals, you just need to add them to the Roles for each App Workspace.
- TCavins
GilbertQ The service principal has direct access and also through the security group. I tried each one individually but I still get the same error.
From my readings, it doesn't sound like I can assign Application permissions in the Azure App for Power BI, it has to be delegated permissions but this goes against what v-sgandrathi has suggested. So I don't know if I need to apply additional settings/permissions as to what I've shared in screenshots or if I need to try something else.
I've verified through SSMS that I can connect to the powerbi://api.powerbi.com endpoint so it's not a network/firewall issue. At least I don't think so.