Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
437 questions
1 answer
Moving multiple SQL server data warehouse databases from On premise to Azure
Dear Experts, I am new to Azure. I have few questions please help me. we have one SQL server dw database per each customer on premise for reporting (using SSRS). Each dw database consists few dimension tables, one fact and one staging table. …
asked 2022-06-24T21:21:02.96+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(240, 46%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESC%3C/text%3E%3C/svg%3E)
Sreenivasa Chary Tatikonda
1
Reputation point
commented 2022-08-01T18:55:44.33+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 26%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHM%3C/text%3E%3C/svg%3E)
HimanshuSinha-msft
19,376
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Can't write Pandas df to ADLS from Synapse Notebook - No such file or directory exists.
I'm using mount point in synapse notebook as shown in MS Azure Docs. I'm using same mount point and same path to read and write spark dataframe and that is working fine but while operation with pandas I'm facing this issue. import pandas as pd …
asked 2022-07-26T04:32:54.44+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(217.60000000000002, 2%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAS%3C/text%3E%3C/svg%3E)
Amit Sopan Shendge
26
Reputation points
accepted 2022-08-01T15:06:06.2+00:00
Amit Sopan Shendge
26
Reputation points
1 answer
How do I add a new string to the folder name? - Azure Synapse Analytics
I would like to add a new string to the Blob folder name when bulk copying data from S3 to Azure Blob Storage. The folder structure of S3 is shown in the following picture Folder Name/yyyy/mm/dd/files. I would like to copy it to Blob…
asked 2022-07-07T06:57:08.23+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(19.2, 80%, 11%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kakehi Shunya (筧 隼弥)
201
Reputation points
commented 2022-08-01T09:57:28.517+00:00
ShaikMaheer-MSFT
37,896
Reputation points Microsoft Employee
1 answer
I would like to add the date and time string in addition to the source file name.
When copying a file from S3 to AzureBlobStorage, I would like to add the date and time string in addition to the source file name. In essence, the S3 folder structure looks like this data/yyyy/mm/dd/files *yyyy=2019-2022, mm=01-12, dd=01-31 …
asked 2022-07-07T14:28:40.487+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESK%3C/text%3E%3C/svg%3E)
Shunya Kakehi
1
Reputation point
commented 2022-08-01T09:56:04.26+00:00
ShaikMaheer-MSFT
37,896
Reputation points Microsoft Employee
0 answers
Synapse Link for Dataverse can't be accessed in pipelines
Hi, we setup the link between dataverse and synapse, sync our table. fine, working. I can run SQL statements in Azure Synapse. but as soon as I try to connect a pipeline activity, like a simple copy, I can't. I have this error: …
asked 2022-07-20T01:12:30.887+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 33%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJR%3C/text%3E%3C/svg%3E)
Jérôme Po
1
Reputation point
commented 2022-08-01T09:44:42.543+00:00
ShaikMaheer-MSFT
37,896
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Issue sinking from Azure Data Factory v2 to Azure Synapse Warehouse with Greek letters
We are trying to import data that contains Greek letters into Azure Synapse Analytics (Data Warehouse) via Azure Data Factory v2. We are getting replacement characters for the Greek characters. Collation for Data Warehouse:…
asked 2022-07-26T23:01:00.773+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(41.6, 99%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECC%3C/text%3E%3C/svg%3E)
Cullen, Cory
21
Reputation points
commented 2022-08-01T09:14:50.817+00:00
ShaikMaheer-MSFT
37,896
Reputation points Microsoft Employee
0 answers
Create synapse credential for power bi
Hi, I wish to create a az synapse analytics credential for power bi that has a scheduled load
asked 2022-07-28T08:12:14.037+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(192, 5%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Alexandra Varadi
1
Reputation point
commented 2022-08-01T08:41:31.48+00:00
ShaikMaheer-MSFT
37,896
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
BlobServiceClient timeout
Problem: we are reaching a timeout error with the BlobServiceClient instead of receving a error that shows that the credentials are invalid: from azure.storage.blob import BlobServiceClient …
asked 2022-07-15T14:39:43.523+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(188.79999999999998, 4%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELW%3C/text%3E%3C/svg%3E)
Lorenz Weinzierl
21
Reputation points
accepted 2022-08-01T07:33:08.96+00:00
Lorenz Weinzierl
21
Reputation points
1 answer
One of the answers was accepted by the question author.
Is there a way to see how expression gets evalated in "if condition"
Hi, I have a very basic doubt. Suppose i have an If condition activity in my pipeline. It has an expression that gets evaluated to a boolean value. I want to see how the expression is interpreted or evaluated in run time, in other words whats…
asked 2022-07-19T05:18:47.827+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 12%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESB%3C/text%3E%3C/svg%3E)
Suba Balaji
11,186
Reputation points
accepted 2022-08-01T06:10:30.83+00:00
Suba Balaji
11,186
Reputation points
1 answer
How to Flatten A Complex Nested JSON Structure in Synapse
As the title suggests, I'm trying to take a complex JSON file, flatten it, and put it into a dedicated SQL pool table. The data is an output from the Shopify API orders endpoint. Here is a sample, it is one single order: [ { …
asked 2022-07-19T01:54:30.367+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 44%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBL%3C/text%3E%3C/svg%3E)
Bill LaLonde
11
Reputation points
commented 2022-08-01T06:00:10.637+00:00
AnnuKumari-MSFT
30,601
Reputation points Microsoft Employee
1 answer
what-is-the-synapse lake database -security-setup-to-allow-reader
I have a requirement where i have to give read access to the user in Azure Data Lake Synapse , is there any way by which we can provide read access to the user ? As of now I have observed that we need to provide user admin access to the synapse…
asked 2022-07-13T12:22:21.19+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 92%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAG%3C/text%3E%3C/svg%3E)
Ankita Gupta
1
Reputation point
commented 2022-08-01T05:42:26.017+00:00
AnnuKumari-MSFT
30,601
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Using XML in Synapse spark pool
Hi, Can anybody help with using the XML in Synapse spark pool with pyspark? I found some articles where they suggest a code like this would load the XML into a data frame, but I get an error when trying it: …
asked 2022-07-27T14:10:39.577+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 45%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELJ%3C/text%3E%3C/svg%3E)
Ljubo Jurkovic
41
Reputation points
accepted 2022-07-28T15:12:14.543+00:00
Ljubo Jurkovic
41
Reputation points
1 answer
Failing select command of external statement
Msg 105019, Level 16, State 1, Line 12 External file access failed due to internal error: 'Error occurred while accessing HDFS: Java exception raised on call to HdfsBridge_IsDirExist. Java exception message: HdfsBridge::isDirExist - Unexpected…
asked 2022-06-27T07:26:59.487+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(204.8, 76%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKS%3C/text%3E%3C/svg%3E)
Kothapalli Srinivasarao
131
Reputation points
commented 2022-07-28T10:56:57.987+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 87%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
Raul Hosu
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Dedicated SQL Pool - Can I import a sql server table or a sql server database into azure Synapse dedicated sql pool?
I have existing sql server tables. I would like to archive them in Azure Synapse Dedicated pool as it is said that one can use T-sql to query in Azure Synapse. My question is: Can I import sql server tables into Azure Synapse ( structure and…
asked 2022-07-26T18:44:46.467+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 99%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENH%3C/text%3E%3C/svg%3E)
Nguyen, Hoa
331
Reputation points
accepted 2022-07-27T13:31:36.427+00:00
Nguyen, Hoa
331
Reputation points
1 answer
Azure Synapse Analytics: Publishing error Error while publishing: Cannot read properties of undefined (reading 'constructor')
I tried to: -delete last changes -remove git and reenable it
asked 2022-07-20T15:01:40.257+00:00
Domenica Lozada Guerra
1
Reputation point Microsoft Employee
commented 2022-07-27T04:40:21.807+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(86.4, 36%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBM%3C/text%3E%3C/svg%3E)
BhargavaGunnam-MSFT
25,976
Reputation points Microsoft Employee
1 answer
How to refresh data in Synapse Lake Database using pipeline DataFlow
I have a pipeline set up in Synapse which runs 2 dataflow activities which is supposed to 1. copy data from Fhir as source to Azure SQL Server as sink and 2. copy data from Azure SQL Server as source to Azure Lake as sink. First, is this the best…
asked 2022-07-14T17:15:58.21+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(25.6, 13%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
TerriblyVexed
51
Reputation points
commented 2022-07-27T02:54:31.42+00:00
BhargavaGunnam-MSFT
25,976
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
synapse spark pool - pyspark load a subset of xml files from given folder
I am limited to use 4 vCores / 32 GB - 3 to 10 nodes configuration of apache spark pool. I am trying to load all xml files from given folder with below code: …
asked 2021-07-18T07:13:52.333+00:00
Dheeraj
351
Reputation points
answered 2022-07-26T20:59:43.153+00:00
Ljubo Jurkovic
41
Reputation points
3 answers
One of the answers was accepted by the question author.
Flowlets question
Hi, I am exploring the usage of flowlets and wonder how I should implement the following scenario: I have a dataflow which reads a source with 10 columns, one of these columns contains a customer number for which I want a flowlet to execute some logic on…
asked 2022-03-11T07:57:14.743+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(275.2, 62%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMV%3C/text%3E%3C/svg%3E)
Marc van der Wielen
46
Reputation points
commented 2022-07-26T18:21:27.273+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(102.4, 32%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJN%3C/text%3E%3C/svg%3E)
John Neubecker
81
Reputation points
0 answers
Data trasnfer across teants using flows
Hi All, I want to copy data from Kusto(MSFT tenant) and ingest to ADLS Gen2(PME tenant). How to do it securely? Can I do it without using App Registration?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(54.400000000000006, 34%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EK%3C/text%3E%3C/svg%3E)
1 answer
LinkedService in Deleting state but not actually being deleted
I'm running the following command via a Azure Powershell job in my Release Pipeline in Azure DevOps: Install-Module Az.Synapse -RequiredVersion 0.7.0 -Scope CurrentUser -Force Remove-AzSynapseLinkedService -WorkspaceName…
asked 2022-07-11T07:24:30.363+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 91%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVS%3C/text%3E%3C/svg%3E)
Victor Seifert
151
Reputation points
commented 2022-07-26T06:37:34.547+00:00
Victor Seifert
151
Reputation points