Unable to connect to Power BI Datasets from Excel

[petesuen]

Hi all

Hopefully I'm asking in the right place!

I have been trying to connect to Power BI Datasets from Excel via "Data" ➡ "Get Data" ➡ "From Power BI".

It is giving me an error that says:

ERROR

This feature could not be started. Close this dialog to ignore the problem or click "Restart" to try again.

Additional Info:

• Clicking "Restart" does nothing
• Everyone from our organisation seems to be having the same issue, and IT could not figure out why. 
• I have the Pro license
• Windows 10
• Excel Version 2102 (Build 13801.20960) 64bit
• This works from Power BI ("Get data" ➡ "Power BI Datasets")

Let me know if additional info is needed.

Thanks!

P.S. - I like how Microsoft just told me to close this and ignore the problem...

[v-janeyg-msft]

Hi, @petesuen 

Can you connect normally after closing this error?

I try to reproduce your scene, it works normally in my version. You can try to upgrade the excel version of one machine.

My version:

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey

[petesuen]

Hi Janey

"Closing" the error does nothing. The exact same error occurs if I "Insert" ➡ "PivotTable" ➡ "From Power BI (xxxx)"

I'll ask IT if they can update Excel, but it seems to tell me I'm already on the latest version (Semi Annual Enterprise Channel)

Cheers

Peter

[v-janeyg-msft]

Hi, @petesuen 

Sorry, I can't reproduce your scene in my computer. Do you use a pro license? 

There is also a function on the service called ‘Analyze in Excel’, can you use it?

Please refer:

Analyze in Excel for Power BI - Power BI | Microsoft Docs

Troubleshooting Analyze in Excel in Power BI Desktop - Power BI | Microsoft Docs

Did I answer your question ? Please mark my reply as solution. Thank you very much.
If not, please feel free to ask me.

Best Regards,

Community Support Team _ Janey

[petesuen]

Everyone in our company should have the Pro license.

It does work while clicking on "Analyze in Excel" on a report from app.powerbi.com

Unfortunately that's an extra step that's unlikely to appease the crowd. 

I have been in touch with Microsoft so I'll report back if I have anything new. 

[v-janeyg-msft]

Hello @petesuen 

Has the problem been solved? How is the progress?

Community Support Team _ Janey

[v-janeyg-msft]

@petesuen 

Okay, hope you can solve the problem soon.

Best Regards,

Community Support Team _ Janey

[petesuen]

Yes I do see my company tenant. I am signed in and unfortunately I get the exact same error message still.

[AbhiSSRS]

Hi!

Do you see your comapny tenant when you are connection to power BI from excel? If you see that it means you are signed in to access Power BI datasets. Go to File -->Account --> Sign In if you are not signed in with your Office account .

From power BI (yout company tenant)