Forum Discussion

LeenBem's avatar
LeenBem
Frequent Visitor
8 months ago
Solved

COM error: Microsoft.AnalysisServices.AzureClient, An error occured while sending the request...

Hello, we have some users that get this error all of a sudden in Excel when they try to connect to PBI Semantic Models to build Excel pivot tables: COM error: Microsoft.AnalysisServices.AzureClient...
Need Help
  • LeenBem's avatar
    LeenBem
    8 months ago

    We found out the issue was related to missing TLS 1.2 and TLS 1.3 registry keys after Windows 10 to Windows 11 upgrade.

    Performed the steps below to solve:
    • Download the file 'Registry_TLS12_13_Win10_to_Win11.reg' 
    • Copy the downloaded file to a folder on the computer of the end user (e.g. C:\Temp)
    • Open a Command Prompt as Administrator
    • Navigate to the folder in which the registry file is saved by using the command below:
    Cd LocationOfFile
         e.g. cd c:\Temp
    • Type the following command and press the Enter button of the keyboard
       Registry_TLS12_13_Win10_to_Win11.reg
      Handy to know, you can start typing Registry and then press the Tab button of the keyboard so that the name is autocompleted
    • Wait until the command has successfully ran
    • Restart the computer
    • Check if the issue still occurs or not
LeenBem's avatar
LeenBem
Frequent Visitor
8 months ago

We found out the issue was related to missing TLS 1.2 and TLS 1.3 registry keys after Windows 10 to Windows 11 upgrade.

Performed the steps below to solve:
  • Download the file 'Registry_TLS12_13_Win10_to_Win11.reg' 
  • Copy the downloaded file to a folder on the computer of the end user (e.g. C:\Temp)
  • Open a Command Prompt as Administrator
  • Navigate to the folder in which the registry file is saved by using the command below:
Cd LocationOfFile
 e.g. cd c:\Temp
  • Type the following command and press the Enter button of the keyboard
     Registry_TLS12_13_Win10_to_Win11.reg
    Handy to know, you can start typing Registry and then press the Tab button of the keyboard so that the name is autocompleted
  • Wait until the command has successfully ran
  • Restart the computer
  • Check if the issue still occurs or not
  • LeenBem's avatar
    LeenBem
    Frequent Visitor
    8 months ago
    Content of file: Registry_TLS12_13_Win10_to_Win11.reg

    Windows Registry Editor Version 5.00

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols]

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2]

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.2\Client]
"DisabledByDefault"=dword:00000000
"Enabled"=dword:00000001

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.3]

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.3\Client]
"Enabled"=dword:00000000

[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\SecurityProviders\SCHANNEL\Protocols\TLS 1.3\Server]
"Enabled"=dword:00000000