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.
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.
Solved! Go to Solution.
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!
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 |
---|---|
15 | |
7 | |
5 | |
3 | |
3 |