Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
10,727 questions
34 questions with Microsoft Dataverse Training-related tags
1 answer
ADF Data Flow Mapping shows 0 rows written to Dataverse sink
Running a simple set of pipelines with data flow mappings to Dataverse sinks. Data flow runs successfully, but Rows Written through interface consistently shows 0 rows. I can see the rows were written by going to the table in Dataverse.
asked 2024-09-26T16:19:01.5633333+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(304, 12%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENG%3C/text%3E%3C/svg%3E)
Noah Gilbert
26
Reputation points
commented 2024-10-10T16:21:14.5133333+00:00
Noah Gilbert
26
Reputation points
1 answer
One of the answers was accepted by the question author.
How to fix "Error loading Control" in Dataverse Form view (on Power Apps)?
I create a table in power apps and added some column, when i try to see the form view form the data, i get the error loading control like this.... but from the microsoft learning module it should look like this : anyone know how to fix it?? This…
asked 2024-09-11T04:03:27.61+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(233.6, 99%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
Asyifa Tasya Fadilah
45
Reputation points
commented 2024-10-03T01:36:44.4833333+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(211.20000000000002, 21%, 30%)' 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)
Syed Saleem Peera
6,235
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
How to enable permissions to import local excel to dataverse with trial account
I have a 30day dev environment to follow along with self-paced Power Platform training. I'm trying to import a local excel file into a dataverse table but it says that I don't have the proper permissions to complete the task with OneDrive. I'm trying to…
![](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(163.2, 6%, 25%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMG%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(224.00000000000003, 86%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
1 answer
Power BI failing with Bulk Load failed error
Power BI refreshes failing with the following error - Microsoft SQL: Cannot bulk load because the file…
asked 2024-09-27T17:40:48.4966667+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, 90%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELD%3C/text%3E%3C/svg%3E)
Lohit Dacha
0
Reputation points
commented 2024-10-01T13:45:57.12+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(268.8, 8%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EST%3C/text%3E%3C/svg%3E)
Smaran Thoomu
16,155
Reputation points Microsoft Vendor
1 answer
Azure Data Factory with Dataverse Sink (mapping data flow) Upsert broken?
Simple ADF data flow with a dataverse sink (Dynamics 365). Created an alternate key on a custom dataverse table and attempting to do an Upsert. I have the Alter row transform with "Upsert if" -> true() I have set the sink to Upsert…
asked 2024-09-30T19:16:42.8+00:00
Noah Gilbert
26
Reputation points
answered 2024-10-01T05:58:47.2333333+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(288, 61%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
phemanth
10,725
Reputation points Microsoft Vendor
0 answers
How to troubleshoot Azure Synapse Link failing to create/modify model.json
Hello, I am having issues with Azure Synapse Link failing to create or modify the model.json file in the blob. This only started happening yesterday. Can someone provide advice on what might be causing this issue and how to resolve it? Thank you. Best…
asked 2024-09-19T20:47:53.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(112.00000000000001, 17%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVR%3C/text%3E%3C/svg%3E)
Vidhya Ramesh
0
Reputation points
edited a comment 2024-09-26T02:27:25.7666667+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(227.2, 46%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
NIKHILA NETHIKUNTA
2,715
Reputation points Microsoft Vendor
1 answer
My trial tenant wont allow me to create an environment
My trial tenant wont allow me to create an environment saying I need 1GB capacity but its a fresh environment This question is related to the following Learning Module
asked 2024-09-20T06:19:48.4466667+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, 77%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETF%3C/text%3E%3C/svg%3E)
Tony Fontanoz
0
Reputation points
commented 2024-09-23T04:36:33.71+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(70.4, 11%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPM%3C/text%3E%3C/svg%3E)
Pradeep M
3,600
Reputation points Microsoft Vendor
1 answer
Columns disappear when I extract data from dataverse using synapse
I am trying to extract data from dataverse source, but when I execute the pipeline, the output file does not contain some columns, I thought it was my fetchXML query but when I executed it using external tools the columns are shown, so : It is not the…
asked 2024-09-06T16:55:18.29+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' %3EAD%3C/text%3E%3C/svg%3E)
Arquitectura Datos
0
Reputation points
commented 2024-09-11T15:20:19.2533333+00:00
phemanth
10,725
Reputation points Microsoft Vendor
3 answers
One of the answers was accepted by the question author.
Azure Data Factory Insert error on Dataverse sink
Hi, I am trying to write data to Dataverse sink(contact entity) using Azure Data factory copy activity. Its giving error as Missing key col for ContactID. This field is guid and should be autogenerated. It seems its because of the 'Upsert' write…
asked 2024-08-06T11:46:02.3766667+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(118.4, 16%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EPS%3C/text%3E%3C/svg%3E)
Pankaj Singh
20
Reputation points
commented 2024-09-05T15:48:48.4233333+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, 86%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
RACHAEL DSOUZA
0
Reputation points
2 answers
One of the answers was accepted by the question author.
Possible mistake in MS Learn content?
Hi, On the page https://zcusa.951200.xyz/en-us/training/modules/create-manage-entities/2-custom-entity, there is a tip as follows: "Make sure that you always verify that the functionality of the table that you want to create already exists in…
asked 2024-08-13T15:45:24.36+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(70.4, 63%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDR%3C/text%3E%3C/svg%3E)
David Rosenthal
20
Reputation points
accepted 2024-09-05T15:19:48.3766667+00:00
David Rosenthal
20
Reputation points
1 answer
One of the answers was accepted by the question author.
How do I open a sandbox account when the error is The user does not have a license that allows environment creation.
How do I open a sandbox account when the error is The user does not have a license that allows environment creation. This question is related to the following Learning Module
asked 2024-09-03T09:17:00.39+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(112.00000000000001, 20%, 20%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ELR%3C/text%3E%3C/svg%3E)
Louis Roux
20
Reputation points
commented 2024-09-04T05:12:41.0433333+00:00
Louis Roux
20
Reputation points
1 answer
One of the answers was accepted by the question author.
Some of the tables are not created with azure synapse link
I created an Azure Synapse Link for Dataverse in Azure Synapse Workspace. The folders with Snapshot and csv files for each dataverse entity are created in Azure Data Lake Storage Gen2. However, not all the tables are showing in workspace Lake database.…
asked 2024-08-13T19:05:25.55+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(201.6, 83%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKV%3C/text%3E%3C/svg%3E)
Kvaratshelya, Vladimir
25
Reputation points
accepted 2024-08-27T12:52:40.0566667+00:00
Kvaratshelya, Vladimir
25
Reputation points
4 answers
Azure Synapse Link for Dataverse Has Fewer Fields than Export To Data Lake
I'm migrating Export to Data Lake to Azure Synapse Link for Dataverse. I know that in some occasions, Synapse Link does not replicate columns if it's sourced from a different table. I'm having an issue with missing columns from DirPartyTable,…
asked 2024-07-17T21:53:12.0466667+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, 73%, 37%)' 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)
Steven Cardella
0
Reputation points
answered 2024-08-23T13:01:57.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(64, 67%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDS%3C/text%3E%3C/svg%3E)
Darin Searcy
10
Reputation points
1 answer
One of the answers was accepted by the question author.
Use Dataverse triggers and actions in Power Automate - where is the Innovation Challenge application?
On unit 5 of 7 it mentions opening this application to start the exercise. Yet for anyone new it doesn't say or link where that application was first created? Any help would be greatly appreciated This question is related to the following Learning…
asked 2024-05-16T22:13:31.4533333+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(166.4, 81%, 26%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMK%3C/text%3E%3C/svg%3E)
Marco Koen
30
Reputation points
commented 2024-08-16T07:01:54.6+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(313.6, 35%, 40%)' 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)
Srinud
2,425
Reputation points Microsoft Vendor
1 answer
Automating Table Activation and Deployment for Synapse Link in Dynamics 365 Dataverse
I am using Synapse Link for Dataverse to bring data from Dynamics 365, where I need to manually activate each table to load data into Azure Data Lake Storage (ADLS) Gen2. I seek a solution to automate this activation process and to deploy the same…
asked 2024-08-02T15:17:52.7333333+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(176, 15%, 27%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ESM%3C/text%3E%3C/svg%3E)
Sriram M
40
Reputation points
commented 2024-08-06T23:39:32.1766667+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)
Bhargava-MSFT
31,031
Reputation points Microsoft Employee
1 answer
Automate the activation of required tables in the Synapse Link for dataverse
Hi All, I am using Synapse Link for Dataverse for loading data from Dynamics 365 to ADLS. I have to manually activate the required tables in the Synapse link inside the dataverse, which is a pain point every time. Q1. Is there a way to automate this…
asked 2024-08-02T15:06:37.99+00:00
Sriram M
40
Reputation points
commented 2024-08-06T23:38:25.1566667+00:00
Bhargava-MSFT
31,031
Reputation points Microsoft Employee
1 answer
How to Automate Synapse Link Table Activation and Deployment Across Environments
I am using Synapse Link for Dataverse to bring data from Dynamics 365, where I need to manually activate each table to get the data loaded into ADLS Gen2. This process is labor-intensive, as I have to navigate to each table and activate them…
asked 2024-08-02T15:51:55.8266667+00:00
Sriram M
40
Reputation points
commented 2024-08-06T23:36:57.4933333+00:00
Bhargava-MSFT
31,031
Reputation points Microsoft Employee
0 answers
Error in unit 5/10
One of the headings reads "Export from Excel in model-driven apps" It should be Export to Excel or Import from Excel
![](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(115.19999999999999, 53%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3E2%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(246.4, 13%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKP%3C/text%3E%3C/svg%3E)
1 answer
One of the answers was accepted by the question author.
Potential Issue with Dataverse Training - Create a position hierarchy
On the Hierarchy Security section, under "Create a position hierarchy", should #5 say "Select the button next to Enable Position hierarchy Model and then ensure that Depth is set to 3 (default)." instead of "Select the button…
asked 2024-07-25T20:18:15.81+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, 66%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHP%3C/text%3E%3C/svg%3E)
Hunter Parker
100
Reputation points
commented 2024-07-30T14:01:40.76+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, 73%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EP%3C/text%3E%3C/svg%3E)
pnaroju
3,125
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
ADF lost access to Dynamics CRM / Dataverse after MFA was turned on
Today my ADF pipelines started throwing errors: Operation on target Process order failed: ErrorCode=DynamicsFailedToConnect,'Type=Microsoft.DataTransfer.Common.Shared.HybridDeliveryException,Message=Failed to connect to Dynamics: Unable to Login to…
asked 2024-05-09T13:00:44.1466667+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(99.2, 20%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAK%3C/text%3E%3C/svg%3E)
Adam Kupiec
196
Reputation points
accepted 2024-07-24T11:55:18.2933333+00:00
Adam Kupiec
196
Reputation points