Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,866 questions
Content
1 answer
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=[],…
asked 2023-03-15T15:04:49.8033333+00:00
Tilahun Hieni
0
Reputation points
commented 2023-03-28T19:05:48.2833333+00:00
Tilahun Hieni
0
Reputation points
0 answers
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", …
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,690 questions
Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
2,866 questions
Microsoft Teams
Microsoft Teams
A Microsoft customizable chat-based workspace.
5,953 questions
3 answers
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.'. …
asked 2022-05-08T11:43:38.72+00:00
Elvin Caldwell
1
Reputation point
edited the question 2023-03-28T17:17:04.4233333+00:00
KranthiPakala-MSFT
35,757
Reputation points Microsoft Employee
0 answers
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
1 answer
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…
asked 2023-03-20T16:40:18.0666667+00:00
sekhemrekhutawysobekhotep
36
Reputation points
answered 2023-03-28T15:26:24.7166667+00:00
BhargavaGunnam-MSFT
10,336
Reputation points Microsoft Employee
0 answers
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,…
asked 2023-03-28T12:06:24.3+00:00
Nathu Mal Omani AZURE
0
Reputation points
edited a comment 2023-03-28T12:09:58.17+00:00
Nathu Mal Omani AZURE
0
Reputation points
1 answer
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…
asked 2023-03-27T12:04:42.96+00:00
CHARAN TEJA NALLURI
1
Reputation point
commented 2023-03-28T10:51:56.6933333+00:00
CHARAN TEJA NALLURI
1
Reputation point
1 answer
One of the answers was accepted by the question author.
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 : …
asked 2021-09-17T15:39:27.083+00:00
Swapnil kumar
26
Reputation points
commented 2023-03-28T10:45:07.4266667+00:00
Sam Njuguna
0
Reputation points
0 answers
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…
asked 2023-03-28T10:39:31.42+00:00
Sri Akshara A
0
Reputation points
asked 2023-03-28T10:39:31.42+00:00
Sri Akshara A
0
Reputation points
0 answers
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":…
asked 2023-03-28T09:58:07.06+00:00
Shahid Ansari (IN)
0
Reputation points
asked 2023-03-28T09:58:07.06+00:00
Shahid Ansari (IN)
0
Reputation points
1 answer
One of the answers was accepted by the question author.
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…
asked 2023-03-27T10:00:13.07+00:00
Richard Tong
20
Reputation points
accepted 2023-03-28T09:20:33.52+00:00
Richard Tong
20
Reputation points
1 answer
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:…
asked 2023-03-27T14:32:36.8066667+00:00
Fabio Carusi
0
Reputation points
commented 2023-03-28T08:16:58.65+00:00
Fabio Carusi
0
Reputation points
1 answer
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 =…
asked 2023-03-26T06:52:15.01+00:00
rahul
0
Reputation points
commented 2023-03-28T07:46:21.14+00:00
PRADEEPCHEEKATLA-MSFT
56,381
Reputation points Microsoft Employee
1 answer
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…
asked 2023-03-23T06:44:57.5966667+00:00
Raghul Kannan
21
Reputation points
commented 2023-03-28T07:40:36.3666667+00:00
PRADEEPCHEEKATLA-MSFT
56,381
Reputation points Microsoft Employee
0 answers
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…
asked 2023-03-21T16:06:33.22+00:00
Timothy Lu
0
Reputation points
commented 2023-03-28T07:38:02.2+00:00
PRADEEPCHEEKATLA-MSFT
56,381
Reputation points Microsoft Employee
0 answers
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 …
asked 2023-03-28T07:20:52.44+00:00
NishimuraChinatsu-9854
521
Reputation points
edited the question 2023-03-28T07:27:18.12+00:00
NishimuraChinatsu-9854
521
Reputation points
1 answer
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…
asked 2023-03-16T12:45:27.1066667+00:00
Anonymous
commented 2023-03-28T07:22:32.47+00:00
PRADEEPCHEEKATLA-MSFT
56,381
Reputation points Microsoft Employee
1 answer
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.
asked 2023-03-27T15:51:26.3633333+00:00
Vinodh247
2,191
Reputation points
commented 2023-03-28T07:08:17.6933333+00:00
AnnuKumari-MSFT
21,321
Reputation points Microsoft Employee
2 answers
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 =…
asked 2023-03-17T10:24:35.3133333+00:00
Gulhasan.Siddiquee
41
Reputation points
edited an answer 2023-03-28T05:53:46.6166667+00:00
ShaktiSingh-MSFT
5,851
Reputation points Microsoft Employee
0 answers
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…
asked 2023-03-27T08:25:22.8133333+00:00
Nagesh CL
391
Reputation points
commented 2023-03-28T01:12:54.7+00:00
BhargavaGunnam-MSFT
10,336
Reputation points Microsoft Employee