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.
How can I add this feature to my data source selections?
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.
@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.⚡
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.
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.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.