cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BobKoenen
Helper IV
Helper IV

Let users connect to dataset via Excel without acces to workspace

HI all, 

 

I have some users who want to use a dataset to make reports in Excel. However the dataset does not show up in Excel. 

The user has build permission on the dataset however he/she does not have acces to the workspace in which the dataset is located. this is because we have one workspace with multiple datasets, some of which end users are not allowed to see. 

Can only users that have full acces tot the workspace use the datasets whithin it?

Is there a way around this without re-organising our entire workspace structure?

1 ACCEPTED SOLUTION
tackytechtom
Super User
Super User

Hi @BobKoenen ,

 

Can the user "see" the dataset in Power BI service? I.e. in the Data hub or Browse pane? It might work for them to create the connection to the dataset via PBi service by clicking on the "analyze in excel" feature. 

 

If that works, the users could save the excel file with the established connection.

 

Let me know if this works 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
v-xinruzhu-msft
Community Support
Community Support

Hi @BobKoenen 

 

 Whether the user has a Power BI pro/ppu license, if you want to analyze in Excel, you need to meet the following conditions, please refer to the link for details。

Analyzing Power BI data in Excel requires that the dataset be in a Power BI Premium workspace or that you have a Power BI Pro or Premium Per User (PPU) license. 

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-connect-power-bi-datasets-excel...

If the user cannot enter the workspace, you can consider upgrading the workspace to premium based on the existing build permission.

 

Best Regards,

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

tackytechtom
Super User
Super User

Hi @BobKoenen ,

 

Can the user "see" the dataset in Power BI service? I.e. in the Data hub or Browse pane? It might work for them to create the connection to the dataset via PBi service by clicking on the "analyze in excel" feature. 

 

If that works, the users could save the excel file with the established connection.

 

Let me know if this works 🙂

 

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

 

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




THis does work indeed. Thankxx

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors