Friday 27 August 2021

Data Factory Pipeline - Schema import failed

 "Schema import failed: The interactive authoring capability is not enabled on the integration runtime 'AutoResolveIntegrationRuntime'. Please enable interactive authoring first and retry the operation."








Go to Data Factory -> Manage -> Integration Runtimes -> AutoResolveIntegrationRuntime










Enable the interactive authoring.


Interactive authoring capability is used during authoring for functionalities like Test connection /Browse and Preview data / Import parameter / Import schema inside managed Virtual Network.
















When enabled, the interactive authoring capability for this VNet integration runtime will disabled after the specified time interval of inactivity (i.e., no interactive commands).


Thursday 26 August 2021

Power BI App workspace creation is disabled

App workspace creation is disabled

Creation of app workspaces is disabled by your tenant admin, or you need permissions to create them. Please contact your tenant admin.

To enable the workspace creation, go to PowerBI Admin portal -> Tenant Settings -> Workspace Settings and enable settings. This option can be restricted to specific AD groups.



Wednesday 4 August 2021

Copy Data from On-Prem to Azure Blob via SSIS failed with TLS error

Copy Data from On-Prem to Azure Blob via SSIS using Feature pack for Azure failed with TLS error:

Error:

Microsoft.DataTransfer.ClientLibrary.BinaryTransfer.Run(),''Type=Microsoft.WindowsAzure.Storage.StorageException,Message=The remote server returned an error: (400) Bad Request.,Source=Microsoft.WindowsAzure.Storage,StorageExtendedMessage=The TLS version of the connection is not permitted on this storage account.

Solution as per Microsoft:

Use TLS 1.2

The TLS version used by Azure Feature Pack follows system .NET Framework settings. To use TLS 1.2, add a REG_DWORD value named SchUseStrongCrypto with data 1 under the following two registry keys.

HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\.NETFramework\v4.0.30319
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\.NETFramework\v4.0.30319

Ref: https://docs.microsoft.com/en-us/sql/integration-services/azure-feature-pack-for-integration-services-ssis?view=sql-server-ver15#use-tls-12