cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Excel Plugin - Cannot connect to Dataset - Web Service Failed

Hello,

 

When trying to connect to a data set within the excel plugin for power bi, I get the error "Failed to Retrieve a List of Groups - request to a web server failed'.

 

I have also done this many times before with no error. I installed the latest updates for excel in power bi.

 

I am also able to select the app within the power bi portal, analyse in excel and it works fine, not sure why it stopped working the other way.

 

Is it to do with permissions?

 

Any help appreciated.

 

Cheers

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User IX
Super User IX

Re: Excel Plugin - Cannot connect to Dataset - Web Service Failed

@johnnyboy_175 , refer if this can help

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2020-feature-summary/#_Excel

 

else log an issue

https://community.powerbi.com/t5/Issues/idb-p/Issues



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Highlighted
Frequent Visitor

Re: Excel Plugin - Cannot connect to Dataset - Web Service Failed

Thanks for the replies guys and gals.

I had to log a ticket with the microsoft team, they advised me that the 'Analyse Excel' function within the power BI tab in excel is no longer functional as of the May 2020 update.

A work around is:
Go to https://app.powerbi.com/
Open your App
Select the '3 dots' next to subscribe at the top right of screen of your app page
Select 'Analyze in Excel'
This now gives you essentially the same fucntion as the tab from excel.

Cheers

View solution in original post

5 REPLIES 5
Highlighted
Super User IX
Super User IX

Re: Excel Plugin - Cannot connect to Dataset - Web Service Failed

@johnnyboy_175 , refer if this can help

https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2020-feature-summary/#_Excel

 

else log an issue

https://community.powerbi.com/t5/Issues/idb-p/Issues



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

Highlighted
Community Support
Community Support

Re: Excel Plugin - Cannot connect to Dataset - Web Service Failed

Hi @johnnyboy_175 ,

 

I'd like to suggest you to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".

 

Best Regards,

Jay

 

Community Support Team _ Jay Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution to help the other members find it.
Highlighted
Helper II
Helper II

Re: Excel Plugin - Cannot connect to Dataset - Web Service Failed

Hi,

 

I've started to get the same exact issue today out of nowhere.  This worked for me previously all the time without any issues.  Does anyone know the fix?

Highlighted
New Member

Re: Excel Plugin - Cannot connect to Dataset - Web Service Failed

Same with mine, just noticed it today while preparing my Dashboard for July

Highlighted
Frequent Visitor

Re: Excel Plugin - Cannot connect to Dataset - Web Service Failed

Thanks for the replies guys and gals.

I had to log a ticket with the microsoft team, they advised me that the 'Analyse Excel' function within the power BI tab in excel is no longer functional as of the May 2020 update.

A work around is:
Go to https://app.powerbi.com/
Open your App
Select the '3 dots' next to subscribe at the top right of screen of your app page
Select 'Analyze in Excel'
This now gives you essentially the same fucntion as the tab from excel.

Cheers

View solution in original post

Helpful resources

Announcements
Upcoming Events

Upcoming Events

Wondering what events you could join or have an event to promote yourself? Check out our Upcoming Events.

Upcoming Events

Community Summit North America – Join Online!

Join this community-driven Power Platform digital event for unbiased support and problem-solving.

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Top Solution Authors