cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dsutt519 Advocate II
Advocate II

Analyze in Excel (only can connect to “My Workspace”)

For some reason I am only able to connect to “My Workspace” and not data in the other group workspaces that I created. This is really odd because (1) I used to be able to do this until I made new groups (2) I am the admin.

Anyone having this same issue?

 

1 ACCEPTED SOLUTION

Accepted Solutions
dsutt519 Advocate II
Advocate II

Re: Analyze in Excel (only can connect to “My Workspace”)

@ankitpatira

Issue #1 has been resolved!!! Today there was a Power BI Publisher update that corrected the issue! 🙂



 It looks like issue #2 has been fixed too! 🙂

Issue #3 still remain open however 😞

View solution in original post

3 REPLIES 3
ankitpatira Community Champion
Community Champion

Re: Analyze in Excel (only can connect to “My Workspace”)

@dsutt519 Just tested this out and it did worked for me regardless of the group workspace. What do you mean by you're only able to connect to data in your workspace ? So you downloaded odc file from group workspace and it didn't work ? or it gave you error when authenticating ?

Highlighted
dsutt519 Advocate II
Advocate II

Re: Analyze in Excel (only can connect to “My Workspace”)

Ankit

Issue #1 (using Excel add in Power BI Publisher for Excel)

I’m unable to connect to any of the GROUP WORKSPACES that I created. I can only connect to My WorkSpace.

 

Issue #2 (Security for Group Workspaces using Analyze in Excel)

Security works great on dashboards/reports, but security does not work if Analyze in Excel is used.

 

Issue #3 (Security in Content Packs)

Security works great in Analyze in Excel/reports/dashboards, but security will stop working if a user makes a copy of the Data Set!!! There is no way to stop a user from making a copy of the data set when creating Content Packs!

 

Ankit these issues are blowing my mind! How can anyone actually use PBI on an enterprise level before these issues are resolved!!? Seems like there are lots of other non-security types of issues too with report formatting etc.!!

dsutt519 Advocate II
Advocate II

Re: Analyze in Excel (only can connect to “My Workspace”)

@ankitpatira

Issue #1 has been resolved!!! Today there was a Power BI Publisher update that corrected the issue! 🙂



 It looks like issue #2 has been fixed too! 🙂

Issue #3 still remain open however 😞

View solution in original post

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Top Solution Authors
Top Kudoed Authors