Analyze in Excel connection problem - NEW failed to connect to the url https //api.powerbi.com

[Anonymous]

I've recently developed a Analyze in Excel report that links to the Dataset published in PBI Service.

From today the report can't be refreshed, and even if I download the .odc file from newly published one. I've got same issue.

After this info window I'm login with my credentials, getting same information window and .odc file is closed.

I'm sure that i have full admin access to the dataset, and its report, can open it in PBI Service.

 Troubleshooting done:

1) Followed the https://docs.microsoft.com/en-us/power-bi/collaborate-share/desktop-troubleshooting-analyze-in-excel and installed the new OLEDB drivers.

2) Updated PBI Desktop to newest version and published dataset again

3) Exported the blank .odc file with a new connection to dataset
4) Exchanged the connction properties with the newly generated .odc file

Any ideas how to fix or troubleshoot this issue ?

[Anonymous · Accepted solution]

System: Windows 7 64-bit
Probable issue: June changes with TLS 1.2 security protocol
Solution: Enable TLS 1.2 in Windows 7 and enforce MS Excel to use this security protocol.

Got this solved by myself. 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! 

[Hemvmeister]

Hi MCzai, I am facing the same issue for one of my users. I tried all the possible steps mentioned on the Internet. But no progress. My user is having windows 10. Please help me with this.