Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
smpa01
Super User
Super User

Connecting PBI Workspace in TE

@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`

 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
1 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)



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

View solution in original post

7 REPLIES 7
bcdobbs
Super User
Super User

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_0-1679905168228.png

 



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

@bcdobbs I see this

 

smpa01_0-1679919237400.png

 

Also, my tabular editor version is 2.16.7.

What do you recommend?

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

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)



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

Works !!!

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

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

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs
bcdobbs
Super User
Super User

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



Ben Dobbs

LinkedIn | Twitter | Blog

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!

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.

 

Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
My custom visualization projects
Plotting Live Sound: Viz1
Beautiful News:Viz1, Viz2, Viz3
Visual Capitalist: Working Hrs

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.