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

Error in "Analyze in Excel" option - Failed to connect while attempting to call cluster resolution

We download our Power BI reports in excel using the "Analyze in Excel" option.

 

We were able to download the file and play around the data in excel until last Friday. We haven't upgraded our gateway or no other changes were done.

 

For some reason, we started seeing the following error while opening the excel file that got downloaded after choosing the "Analyze in Excel" option.

 

Error:- Failed to connect to the URL "https://api.powerbi.com" while attempting to call cluster resolution.

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Advocate I
Advocate I

Re: Error in "Analyze in Excel" option - Failed to connect while attempting to call cluste

Solved this by myself.

THe issue is related with Security Protocol, for Windows 7 it needs to be enabled and enforced by MS Excel.


Solution:

1) Install the newest driver (64-bit)
https://docs.microsoft.com/en-us/power-bi/collaborate-share/desktop-troubleshooting-analyze-in-excel

2) Enable TLS 1.2 in the registry of your machine (this step may be optional if you install step 3)
https://help.runbox.com/enabling-tls-1-2-on-windows-7/
3) Apply the Easy FIX by installing this or manually by steps described below. (I installed the EasyFix).
https://support.microsoft.com/en-gb/help/3140245/update-to-enable-tls-1-1-and-tls-1-2-as-default-sec...

 

You're welcome! 

 

 

View solution in original post

11 REPLIES 11
Highlighted
Advocate I
Advocate I

Re: Error in "Analyze in Excel" option - Failed to connect while attempting to call cluste

Upvoting. Same issue here!

Updated the PowerBI application, republished dataset again, and updated the OLEDB drivers to the newest.

The issue still exist - for previously created report and for the new as well.

Followed also:

https://docs.microsoft.com/en-us/power-bi/collaborate-share/desktop-troubleshooting-analyze-in-excel

 

Capture.JPG

 

Highlighted
New Member

Re: Error in "Analyze in Excel" option - Failed to connect while attempting to call cluste

We are having a similar issues since late last week.  @Suman-PowerBI , @MCzai , are your machines running Win 7 or Win 10?  Our problems are with Win 7 machines.

Highlighted
Regular Visitor

Re: Error in "Analyze in Excel" option - Failed to connect while attempting to call cluste

Our machines are running on Win 7.

Highlighted
Advocate I
Advocate I

Re: Error in "Analyze in Excel" option - Failed to connect while attempting to call cluste

Win7 as well. That's a nice hint. Is there a possibility to report this to MS, as it was possible few years back ?

Highlighted
New Member

Re: Error in "Analyze in Excel" option - Failed to connect while attempting to call cluste

We're going to first troubleshoot using these suggestions, then open a ticket with MS.

 

https://docs.microsoft.com/en-us/power-bi/collaborate-share/desktop-troubleshooting-analyze-in-excel

Highlighted
Regular Visitor

Re: Error in "Analyze in Excel" option - Failed to connect while attempting to call cluste

 As I mentioned in my initial post, it was working fine until 2 days ago. 

 

I have gone through the following document and I can confirm that we have the correct versions of the plugins.

https://docs.microsoft.com/en-us/power-bi/collaborate-share/desktop-troubleshooting-analyze-in-excel

 

Highlighted
Advocate I
Advocate I

Re: Error in "Analyze in Excel" option - Failed to connect while attempting to call cluste

Solved this by myself.

THe issue is related with Security Protocol, for Windows 7 it needs to be enabled and enforced by MS Excel.


Solution:

1) Install the newest driver (64-bit)
https://docs.microsoft.com/en-us/power-bi/collaborate-share/desktop-troubleshooting-analyze-in-excel

2) Enable TLS 1.2 in the registry of your machine (this step may be optional if you install step 3)
https://help.runbox.com/enabling-tls-1-2-on-windows-7/
3) Apply the Easy FIX by installing this or manually by steps described below. (I installed the EasyFix).
https://support.microsoft.com/en-gb/help/3140245/update-to-enable-tls-1-1-and-tls-1-2-as-default-sec...

 

You're welcome! 

 

 

View solution in original post

Highlighted
Regular Visitor

Re: Error in "Analyze in Excel" option - Failed to connect while attempting to call cluste

Thank you very much. I installed EasyFix and that resolved my issue.

Highlighted
Frequent Visitor

he Re: Error in "Analyze in Excel" option - Failed to connect while attempting to call cluste

It does not work for me

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Come join us today! Find your favorite faces from the community presenting at the Power Platform Community Conference!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Users online (1,969)