Connect Excel Desktop to Power BI dataset

[Momme]

hello all,

I am using an Excel with a Microsoft 365 Apps for Enterprise license. 

Microsoft® Excel® für Microsoft 365 MSO (Version 2203 Build 16.0.15028.20178) 64 Bit

I am also using a Power BI Pro license.

After enabling connected experiences and installing all the rest: Power Pivot etc. and all the three-letter connectivity apps.

What I didnt do is: switch on any MS-Office Insider services.

When I choose 'Analyze in Excel' from the dataset, I get an excel without any live data connections, in Excel the option 'connect to Power BI dataset' is missing.

 Does anyone have experience with this kind of issue or know what the problem could be?

thanks a lot in advance!

Markus

[Momme]

My admin enlisted me to the Insider Builds subscription now - still no success.

Are there any details missing in my description to maybe find a solution to this problem @v-yingjl, any ideas what could be done? 

[Momme]

@dhorrall this is not related, I am afraid. I don't even have the option to connect to a Power BI dataset. 

[dhorrall]

I am having a similar issue, but perhaps not exactly the same.  Unitl the last week or so, he has been able to connect Excel to PowerBI Datasets.  But now, we both get this message. (see screenshot)  I had not tried this functionality before, but I get the same error as he does. Not sure if it is a tennent setting somewhere or what is going on.  Do you get the same message?  Maybe the issues are related.

Here are the steps

1) Open new excel workbook

2) Go to Data Tab

3) Get Data

4) "From Power BI"

5) Then we get the error I posted above.  

[Momme · Accepted solution]

okay, this has been solved by my administrators. It turned out, that my Excel account was not activated and therefore could not connect to the Power BI workspace of my company.

thanks anyway for your interest and time.