Forum Discussion
Analyze in Excel connection error today
Contacted Microsoft support to help and changed registry keys on the Win7 machine.
But not working.
The worksaround is to use Win10.
Hi, Anonymous
I'd like to suggest you check the following troubleshooting sections with corresponding error message.
- Update Excel libraries for the OLE DB provider
- Determining whether you need to update your Excel libraries
- Connection cannot be made error
- Forbidden error
- No data models
- Token expired error
- Unable to access on-premises Analysis services
- Can't drag anything to the PivotTable Values area (no measures)
For further information, please refer to the document .
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
How to enforce TLS 1.2 in Win7 SP1?
I've tried below in PowerShell. Not work
Hi, Anonymous
You can force the gateway to communicate with Service Bus by using HTTPS instead of direct TCP. Starting with the June 2019 gateway release and based on recommendations from Service Bus, new installations default to HTTPS instead of TCP. This default behavior doesn't apply to updated installations.
By default, the gateway uses Transport Layer Security (TLS) 1.2 to communicate with the Power BI service. To ensure all gateway traffic uses TLS 1.2, you might need to add or modify the following registry keys on the machine that runs the gateway service.
[HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319]"SchUseStrongCrypto"=dword:00000001 [HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\.NETFramework\v4.0.30319]"SchUseStrongCrypto"=dword:00000001I'd like to suggest you refer to the document for further help.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Contacted Microsoft support to help and changed registry keys on the Win7 machine.
But not working.
The worksaround is to use Win10.