Forum Discussion
Community ChampionConnecting PBI Workspace in TE
How can I conect to a PBI Premium Workspace through TE.
I followed this and I still can't conenct.
I can use DAX stufio to connect o the same workspace but TE is not working.
Does any1 know what am I doing wrong
I am using this same string in TE as DAX Studio
`powerbi://api.powerbi.com/v1.0/myorg/foo bar Workspace`
I think getting the latest version of Tabular Editor 2.17.3 should fix it.
The release notes on 2.17.0 which came after 2.16.7 has:
- Set AS_EnforceAdalUsage default (which would otherwise prevent the AAD popup to appear when connecting),
Sounds like it may be your issue
(Release Tabular Editor 2.17.0 · TabularEditor/TabularEditor · GitHub)
- Set AS_EnforceAdalUsage default (which would otherwise prevent the AAD popup to appear when connecting),
7 Replies
- bcdobbs
Does it give any error message?
Have you got xlma read/write turned on in tennant settings?Aside from that check you're running latest version of TE and you've got the latest MSOLAP library installed https://learn.microsoft.com/en-us/analysis-services/client-libraries?view=asallproducts-allversions#download-the-latest
smpa01Does it give any error message? - no it simply does not connect.
Have you got xlma read/write turned on in tennant settings? - IT controls that, I have no visibilty on that. The fact that I can use DAX studio and SSMS to connect to workspace and query ssas db in datfloaw, dataset, datamart..is that enough indication that read/write is turned on. Please let me know.
- bcdobbs
You're right it's not the read/write (have tested my end and can't recreate a situation where TE can connect and DAX Studio can't).
Only thought is that TE2 looks like it uses it's own TOM libraries rather than system installed ones.
What version numbers do you see for these files:- bcdobbs
I think getting the latest version of Tabular Editor 2.17.3 should fix it.
The release notes on 2.17.0 which came after 2.16.7 has:
- Set AS_EnforceAdalUsage default (which would otherwise prevent the AAD popup to appear when connecting),
Sounds like it may be your issue
(Release Tabular Editor 2.17.0 · TabularEditor/TabularEditor · GitHub)
- Set AS_EnforceAdalUsage default (which would otherwise prevent the AAD popup to appear when connecting),