Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
When I select Data from the menu and choose Get Data I don't see the "From Power BI dataset" as one of the options.
I have:
How can I add this feature to my data source selections?
Same issue here, any ideas?
I am facing the same issue and already tried out the solution proposed (re-enable connection experiences) and did not work. Any idea?
You need to enable connection experiences in Excel. To enable follow the instructions: https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-connect-excel-power-bi-datasets
I'm having the same problem.
I don't have the option.
But other colleagues do have the option.
I'm Premium user of Power BI.
If somebody could help me with this issue, will be really appreciated.
I need to add the power bi button from excel to import datasets from power bi Services.
were you ever able to solve this issue? I'm having this occur with one of our new hires, and I've double checked all his permissions, trying to find any documentation to see if it is maybe an excel setting?
Have you read through the following document,and have you spoken with your Tenant Administrator?
If your requirement is solved, please make THIS ANSWER a SOLUTION ✔️ and help other users find the solution quickly. Please hit the LIKE 👍 button if this comment helps you. Proud to be a Super User!
not yet. I have tried using the file import from a SharePoint list and from OneDrive. Neither one works.
@JimTheBIGuy you need to change the O365 channel to current channel
Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
When I click on the "About Excel" button it opens a window with this info:
Microsoft Excel for Microsoft 365 MSO (16.0.13127.21210)
There is no option to change to current channel.
Hi @JimTheBIGuy ,
Here are some requirements for using Analyze in Excel, Please check the document.
https://docs.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel#requirements
Best Regards,
Jay
I looked at all of the prerequisites listed above.
I am running O365 Excel, i.e. the current version. I have a premium license and am admin on the workspaces containing the underlying datasets.
I can choose analyze in Excel from the service and it works fine. My issue is with the ability to open Excel and have the option to connect to Power BI show up under the Get Data menu option. This is disconnected from the service as I am trying to access from Excel.
Yes, this is the same scenario for me, is there a way or a guide towards the enabling of the option?
would appreciate some solution
@JimTheBIGuy Are you using O365 E3 license?
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I thought this was resolved but now I have other users who are having the same problem. Is there a solution for this?
Hi,
Once upgraded to pro license, we just signed out and sign in back to excel. After sometime the option got enabled automatically.
Yes I am using an E3 license
any solution on the above issue?
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
93 | |
89 | |
83 | |
75 | |
49 |
User | Count |
---|---|
142 | |
141 | |
110 | |
69 | |
55 |