From Power BI dataset not showing in Excel Get Data option

[JimTheBIGuy]

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:

• Downloaded and installed the latest Analyze in Excel options from Power BI service
• Looked in add ins under options in Excel. The option for Power BI is not an showing
• In the Power BI service I selected a dataset and chose "Analyze in Excel". This works and creates a spreadsheet with the correct connection.

How can I add this feature to my data source selections?

[manuelcoto]

I am facing the same issue and already tried out the solution proposed (re-enable connection experiences) and did not work. Any idea?

[MichaelVictor]

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

[delcastilloc]

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.

[Digitalbiju]

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?

[foodd]

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

[foodd]

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!

[JimTheBIGuy]

not yet. I have tried using the file import from a SharePoint list and from OneDrive. Neither one works.

[parry2k]

@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.⚡

[JimTheBIGuy]

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.

[v-jayw-msft]

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 

• Analyze in Excel is supported for Microsoft Excel 2010 SP1 and later.
• Excel PivotTables do not support drag-and-drop aggregation of numeric fields. Your dataset in Power BI must have pre-defined measures. Read about creating measures.
• Some organizations may have Group Policy rules that prevent installing the required Analyze in Excel updates to Excel. If you’re unable to install the updates, check with your administrator.
• Analyze in Excel requires that the dataset be in Power BI Premium or that the user have a Power BI Pro license. To learn more about the differences in functionality between license types, take a look at the Power BI features comparison section of Power BI pricing.
• Users can connect to datasets through Analyze in Excel if they have permission for the underlying dataset. A user could have this permission in a few ways, such as having the Member role in the workspace containing the dataset, or having Build permission for a dataset in a workspace or in an app that contains the dataset. Read more about Build permission for datasets.
• Guest users can't use Analyze in Excel for datasets sent from (originating from) another tenant.
• Analyze in Excel is a Power BI service feature, and isn't available in Power BI Report Server or Power BI Embedded.
• Analyze in Excel is only supported on computers running Microsoft Windows.

Best Regards,

Jay

[JimTheBIGuy]

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.

[cbabel]

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

[parry2k]

@JimTheBIGuy Are you using O365 E3 license?

[JimTheBIGuy]

I thought this was resolved but now I have other users who are having the same problem. Is there a solution for this?

[Anonymous]

Hi,

Once upgraded to pro license, we just signed out and sign in back to excel. After sometime the option got enabled automatically.

[JimTheBIGuy]

Yes I am using an E3 license

[Anonymous]

any solution on the above issue?