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.
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.
Helper VGilbertQ 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.