Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@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
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
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.
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?
@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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |