Content
Encounter error while reading parquet files. One possible cause: Parquet column cannot be converted in the corresponding files
Py4JJavaError: An error occurred while calling o2391.count. : org.apache.spark.sql.catalyst.errors.package$TreeNodeException: execute, tree: Exchange SinglePartition, ENSURE_REQUIREMENTS, [id=#216] +- *(5) HashAggregate(keys=[],…


Copying the files from the Microsoft Teams channel to ADLS using ADF
i am trying to copying the files from the Share point Teams folder to ADLS using ADF, however i am running into errors like . is it possible to do this using the ADF or is its permissions issue { "errorCode": "2108", …
Issue with ADF Pipeline loosing Connectivity Refreshing Analaysis services Model
Erroor Recieved - Operation on target ThrowErrorOnFailure failed: Error calling the endpoint ''. Response status code: 'NA - Unknown'. More details: Exception message: 'NA - Unknown [ClientSideException] Invalid URI: The URI scheme is not valid.'. …


How to create a dataset to dblink
Hello, is it possible to create a dataset that connects to an Oracle dblink? In the list of tables shown there are no references to the dblink. Thank you Massimiliano
azure synapse new Link connection error: Failed to enable Synapse Link on the source due to 'The database master key is missing.'.
I am creating a new azure synapse 'Link connection' ... after defining everything including source SQL server ( which lives on NON azure ) and destination Dedicated SQL pool I hit the Start button and get error Failed to enable Synapse Link on the…


Unable to access Azure Synapse Workspace
Hi, I have been using Synapse Analytics for around 2 months but today when I have tried to connect with Azure Synapse Analytics workspace. It is showing me some error while connecting. Region: North Europe I have added Screenshot of Error. kindly,…


Copy Dataverse data from ADLS Gen2 to Azure SQL DB leveraging Azure Synapse Link template in Synapse not working for multiple entities
Hi, While using a Template related to Copy data from Dataverse to SQL via Azure Synapse link, templates while configuring for multiple entities are not working. Issues I was facing After configuring Dataflows, pipelines are working successfully, but…


Getting "Microsoft SQL: The target principal name is incorrect. Cannot generate SSPI context." error when trying to connect Synapse Studio to Power BI
Getting "Microsoft SQL: The target principal name is incorrect. Cannot generate SSPI context." error when trying to connect Synapse Studio to Power BI when running the downloaded .pbids file according to the steps in this article : …


How to fix the issue when i read a column from salesforce the line separated values are not copied.
Hi , I have a pipeline thats running fine, but when its fetching data from Salesforce the line separated value is not considered eg: in salesforce the value is : order akc While copied in synapse it is : order the line separated value akc is not…


Azure Synapse workspace validation failed
Hi Team, I am trying to create Azure Synapse workspace but got failed during validation with below error.As I am new to this Azure Synapse,request your help here. { "code": "InvalidTemplateDeployment", "message":…


The Synapse Link workspace I created isn't showing when creating a new link in Dataverse
Hi all, I've created an Azure Synapse Link worksapce in Azure for the purposes of transferring data from our Dataverse environment. When I go through Power Apps to create the link to Dataverse, the Synapse workspace is not showing in the "Storage…


Synapse Analytics pipeline error: ErrorCode=PolybaseOperationFailed,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Error happened when loading data into SQL Data Warehouse. Operation: 'Polybase operation'.,Source=Microsoft.Data
Hello there! I try to copy SQL server tables to a SQL pool using a pipeline of Synapse Analytics and a Copy data activity, but I receive this error message: Synapse Analytics pipeline error:…


pyodbc.ProgrammingError: ('42000', "[42000] [Microsoft][ODBC SQL Server Driver][SQL Server]Credential with name 'SharedAccessToken' has not been found or you do not have the permission to access it. (16548)
import pyodbc import urllib.parse server = 'abc.sql.azuresynapse.net' database = '' username = '' password = '' sas_token = 'z' # Build the connection string account_name = 'a' file_system_name = 'b' directory_name = 'c' file_name = 'd' credential =…


External table 'dbo.V1' is not accessible because content of directory cannot be listed.
Hi, I get the error "External table 'dbo.V1' is not accessible because content of directory cannot be listed". My managed identity has "storage data contributor" role on the specified storage account. Only Azure AD accounts with…


Synapse crashes browser when uploading a workspace package
Every time I attempt to upload a package to the managed libraries in synapse, it causes a crash of my entire browser. This behavior occurs when I click on the file upload button, and has been consistent across multiple browsers. Is there a known problem…


it shows 2week_ago cannot start with a numbert and I cannot do it well. Please let me know how to solve this problem.
I would like to get data for every two weeks from daily dates. I have created it in one step, but it shows 2week_ago cannot start with a numbert and I cannot do it well. Please let me know how to solve this problem. (ex.) 2023/03/14~2023/03/28 …


How do I view the Dedicated pool as a Azure SQL DB
Hi, I have a Stream analytics job. I need to bring one reference input from a Synapse dedicated pool. Can I view or configure the dedicated pool as a Azure SQL DB so that I can bring the data in my ASA job (as the ASA only allows Azure SQL DB). Thanks…


how to fasten the pipeline file copy activity in synapse
How can we improve the speed of file copy in azure synapse pipeline copy activity, Especially the network throuput speed when the files are in ADLS location.


Rename a column name (containing dot in it) of a table
I want to change a column name of a table . But issue is that column name is containing dot in it . which is creating issue while I am executing below statement.:- I can not drop the table as it contains huge and important data expecting Column name =…


Cannot find Microsoft.Synapse/workspaces/linkedServices
Hello Team, Our client does not provide "Synapse Artifact Publisher" role for deploying synapse artifacts to higher environments. As per their policy, they create custom roles and add required RBAC permissions and assign them to the service…

