Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,211 questions
1 answer
One of the answers was accepted by the question author.
Unable to detect Linked Service of an asset in Azure Data Factory
I have a SQL server connected as a Linked Service created in Azure Data Factory by storing of Connection String in Key Vault. I have Registered the same SQL Server in Azure Purview by creating a Credential with Password stored in Key Vault. I…
asked 2021-05-31T13:55:09.617+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(144, 83%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESV%3C/text%3E%3C/svg%3E)
Sukumar Vinnakota
311
Reputation points
accepted 2021-06-01T06:39:55.99+00:00
Sukumar Vinnakota
311
Reputation points
1 answer
Azure purview : Auto mapping glossary and classification
Are there any method to do auto glossary and data classification auto mapping in Azure Purview ? After the data discovery
asked 2021-05-20T02:03:12.86+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(137.6, 40%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
sakuraime
2,321
Reputation points
commented 2021-05-31T12:14:06.183+00:00
PRADEEPCHEEKATLA-MSFT
85,826
Reputation points Microsoft Employee
1 answer
When will Purview scanning feature for Azure Synapse Serverless SQL pool made available?
Hi, currently I am using Synapse Serverless SQL Pool. However I am unable to scan in Purview since it doesnt support scanning to serverless pool and I was being informed that this feature is being developed. May I know when is the expected completion…
asked 2021-05-24T03:16:20.573+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(294.40000000000003, 44%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMM%3C/text%3E%3C/svg%3E)
Muhammad Mukhtar
1
Reputation point
commented 2021-05-28T12:22:23.14+00:00
PRADEEPCHEEKATLA-MSFT
85,826
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
Why I am not able to see Avro file schema in Purview?
I am unbale to see schema details in Azure purview for Avro format files. Please help me
asked 2021-05-26T06:39:08.917+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(307.2, 12%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
prashanth tn
26
Reputation points
accepted 2021-05-27T11:08:30.43+00:00
prashanth tn
26
Reputation points
1 answer
One of the answers was accepted by the question author.
Azure Purview - Query on General Availability
Any idea when Azure Purview would be available with General Availability?
asked 2021-05-26T06:55:22.54+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(9.6, 66%, 10%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPT%3C/text%3E%3C/svg%3E)
Patil, Tushar
21
Reputation points
commented 2021-05-27T03:55:34.257+00:00
Patil, Tushar
21
Reputation points
0 answers
Azure Purview Adls2 Connection-Error: (3831)
We followed below approach for scanning ADLS 2 [Blog storage have contributor rights for , got error Error: (3831) Failed to access the ADLS Gen2 storage account with the given credentials
asked 2021-05-07T18:59:03.317+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(198.4, 48%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDN%3C/text%3E%3C/svg%3E)
Dondapati, Navin
281
Reputation points
commented 2021-05-25T00:29:48.017+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(134.4, 9%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
KranthiPakala-MSFT
46,447
Reputation points Microsoft Employee
0 answers
Unable to get pipelinerun in purview
I have integrated my purview account to Data Factory. When I run my pipeline which has web activity and copy activity with source as 'REST API' and sink as json dataset in 'Azure Blob Storage' , I was unable to locate pipeline runs in purview. When i…
asked 2021-05-10T08:17:44.567+00:00
Sukumar Vinnakota
311
Reputation points
commented 2021-05-20T14:42:27.6+00:00
Sukumar Vinnakota
311
Reputation points
1 answer
One of the answers was accepted by the question author.
Scan PowerBI of Different Tenant
Can Purview scan PowerBI which is present in a different Tenant
asked 2021-05-07T11:05:33.307+00:00
Sukumar Vinnakota
311
Reputation points
accepted 2021-05-10T07:17:15.437+00:00
Sukumar Vinnakota
311
Reputation points
2 answers
One of the answers was accepted by the question author.
Which Power BI license is required to scan as tenant for Azure Purview?
Hi, I have Power BI pro license. I am recently started exploring Purview and stumbled this documentation https://learn.microsoft.com/en-us/azure/purview/register-scan-power-bi-tenant. Does pro license sufficient for this purpose or do I need premium…
asked 2021-05-04T02:22:06.137+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(35.2, 90%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Muhammad Harinn Hizhairie Mukhtar
41
Reputation points
commented 2021-05-10T04:17:12.02+00:00
Muhammad Harinn Hizhairie Mukhtar
41
Reputation points
0 answers
Azure Purview on-premises scan
Hi, I have a problem with on-premises scan using Azure Purview. I have installed self hosted integration runtime (and Purview is able to list all object from configured database) but face a problem when trying to scan configured database. Error…
asked 2021-02-10T14:32:32.647+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(198.4, 7.000000000000001%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJM%3C/text%3E%3C/svg%3E)
Jakub Miasik
1
Reputation point
commented 2021-05-06T17:20:45.027+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(243.2, 7.000000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJD%3C/text%3E%3C/svg%3E)
Juanes, Diego Hernan
96
Reputation points
3 answers
One of the answers was accepted by the question author.
Unable to connect to Azure SQL or on-premises adventureworks database
Hi - After i register Azure SQL in Purview and select 'New Scan' , I am getting below error Error: (3860) Failed to access the Azure SQL database. Inner Code:20500 Below error for on-premises Error: (20500) Failed to get the secret from…
![](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(169.60000000000002, 31%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
![](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(195.2, 42%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EM%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Is it possible to move Azure Purview to a different Region?
Hi, Initially, we deploy our Azure Purview in the East US region. I've heard Purview is now available in Australia East region. I would prefer to move it if possible instead of delete and re-create a new Purview in our preferred region. Any tips/help…
asked 2021-04-19T01:30:25.407+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(307.2, 9%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJT%3C/text%3E%3C/svg%3E)
Justin Tran
21
Reputation points
commented 2021-04-21T00:20:21.61+00:00
SUNOJ KUMAR YELURU
14,026
Reputation points MVP
5 answers
Error trying to scan Power BI from azure purview
working with a client to setup azure purview and the one issue we have is with Power BI scanning. We have created a security group and added the purview managed identity into that group and granted that group access to use the PBI admin API in the tenant…
asked 2021-03-31T15:43:58.047+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(243.2, 83%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJP%3C/text%3E%3C/svg%3E)
James Perry
116
Reputation points
answered 2021-04-16T16:31:58.433+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(121.6, 81%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDG%3C/text%3E%3C/svg%3E)
Dirk Grobbelaar
1
Reputation point
0 answers
Self hosted Integration Run time
We have a two Sql Server machines and in one Sql Server we already have a self hosted IR installed for Azure Data Factory, but we want one more self hosted IR for Azure Purview. Since in machineA Self hosted IR is already installed, we have installed one…
asked 2021-03-26T08:03:26.89+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(57.599999999999994, 19%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVE%3C/text%3E%3C/svg%3E)
Viji Ekambaram
31
Reputation points
commented 2021-04-07T19:43:56.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(204.8, 44%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESS%3C/text%3E%3C/svg%3E)
Saurabh Sharma
23,791
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
Purview relational database table relations
Does Azure Purview show table relationships(references) for captured SQL Server tables? The related tab shows all tables in the schema! Thanks
asked 2021-01-28T07:44:20.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(22.400000000000002, 42%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJH%3C/text%3E%3C/svg%3E)
Janaka Hewavitharana
156
Reputation points
commented 2021-04-07T04:41:24.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(249.60000000000002, 6%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
Medha Bhatt
6
Reputation points
3 answers
One of the answers was accepted by the question author.
Unable to provision Azure Purview since release
Unable to provision Azure Purview service since release Validation failed with error: The template deployment 'Microsoft.AzurePurviewGalleryPackage-datagov01' is not valid according to the validation procedure. The tracking id is…
asked 2021-04-03T14:30:58.847+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(32, 56.00000000000001%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mudassar A
486
Reputation points
commented 2021-04-06T18:30:26.807+00:00
KranthiPakala-MSFT
46,447
Reputation points Microsoft Employee
2 answers
One of the answers was accepted by the question author.
The template deployment 'Microsoft.AzurePurviewGalleryPackage-pvw-chiepurview' is not valid according to the validation procedure. The tracking id is 'c64fc48e-f5a0-42a2-a967-d820e19b7a2b'. See inner errors for details.
I am getting this error message when I try to create a Purview account: Validation failed with error: The template deployment 'Microsoft.AzurePurviewGalleryPackage-pvw-chiepurview' is not valid according to the validation procedure. The tracking id is…
asked 2021-03-23T17:44:10.49+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(38.4, 31%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EJC%3C/text%3E%3C/svg%3E)
JeannieH(COLLABERA INC)
391
Reputation points
accepted 2021-03-30T11:07:32.703+00:00
JeannieH(COLLABERA INC)
391
Reputation points
0 answers
How do I configure the SQL Database firewall to allow integration runtime to access?
I'm attempting to run a scan from Purview on an on-prem SQL Server database on my laptop. The credential uses a key vault with the correct password, Azure sees the Integration Runtime running on my laptop, but I keep getting this error when I try to…
asked 2021-03-18T20:13:25.903+00:00
JeannieH(COLLABERA INC)
391
Reputation points
commented 2021-03-25T10:43:10.627+00:00
PRADEEPCHEEKATLA-MSFT
85,826
Reputation points Microsoft Employee
2 answers
Data Lineage on SSIS with Azure Purview
Hi, I'm testing Azure Purview. I have some projects with SSIS and I have migrated the projects to Azure Data Factoy. The projects and its pacakges work correctly. On some data flows I have used SQL Commands (Components) to update records on destination…
asked 2021-03-13T11:27:31.167+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(300.8, 82%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERL%3C/text%3E%3C/svg%3E)
Raúl Jareño Zamora
1
Reputation point
commented 2021-03-19T20:19:15.667+00:00
Raúl Jareño Zamora
1
Reputation point
1 answer
One of the answers was accepted by the question author.
Problem using POSTMAN to call REST APIs: "error_description": "AADSTS7000215: Invalid client secret is provided.\r\nTrace ID:
I'm trying to use the REST APIs to delete Assets in Purview but I keep this error: "error_description": "AADSTS7000215: Invalid client secret is provided.\r\nTrace ID: I have an App Registration that is assigned both the Owner…
asked 2021-03-19T18:08:29.77+00:00
JeannieH(COLLABERA INC)
391
Reputation points
accepted 2021-03-19T19:18:56.56+00:00
JeannieH(COLLABERA INC)
391
Reputation points