Forum Discussion
Solved
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...
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
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
Same with mine, just noticed it today while preparing my Dashboard for July