Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to Solution.
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❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
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.
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.
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❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
THis does work indeed. Thankxx
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.