Microsoft Q&A

Azure Synapse Analytics

2,866 questions

An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.

Browse all Azure tags

2,866 questions with Azure Synapse Analytics tags

Sort by: Updated
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=[],…

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
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
asked 2023-03-28T18:46:38.83+00:00
Murali 216 Reputation points
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.'. …

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
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

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
asked 2023-03-28T15:31:50.55+00:00
63877242 1 Reputation point
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…

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
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,…

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
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
6,690 questions
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…

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
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 : …

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
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…

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
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":…

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
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…

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
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:…

Azure SQL Database
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
Azure Data Lake Storage
Azure Data Lake Storage
An Azure service that provides an enterprise-wide hyper-scale repository for big data analytic workloads and is integrated with Azure Blob Storage.
938 questions
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 =…

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
Azure Storage Accounts
Azure Storage Accounts
Globally unique resources that provide access to data management services and serve as the parent namespace for the services.
1,684 questions
Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
13,603 questions
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…

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
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…

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
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 …

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
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…

Azure SQL Database
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
Azure Stream Analytics
Azure Stream Analytics
An Azure real-time analytics service designed for mission-critical workloads.
236 questions
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.

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
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 =…

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
Azure Active Directory
Azure Active Directory
An Azure enterprise identity service that provides single sign-on and multi-factor authentication.
13,603 questions
Azure SQL Database
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…

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
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