Connecting PBI Workspace in TE

[smpa01]

@bcdobbs @GilbertQ 

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`

[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:

[smpa01]

@bcdobbs I see this

Also, my tabular editor version is 2.16.7.

What do you recommend?

[bcdobbs · Accepted solution]

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)

[smpa01]

Works !!!

[smpa01]

Many thanks for looking into it. I will report back.

[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#...

[smpa01]

Does 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.