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.
5,003 questions
37 questions with Microsoft Dataverse Training-related tags
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…
![](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, 26%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ED%3C/text%3E%3C/svg%3E)
1 answer
Copy Dataverse data into Azure SQL using Synapse Link
Im using Azure Synapse pipeline to copy data from Dataverse to Azure SQL DB. For large tables, it is only copying 10 million records and it is not inserting after. I have about 15 mil records. I dont see any settings limitation anywhere on the pipeline.…
asked 2024-10-23T15:49:18.2433333+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(246.4, 55.00000000000001%, 33%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMR%3C/text%3E%3C/svg%3E)
Murali Ramasamy
5
Reputation points
edited the question 2024-11-05T04:40:03.8733333+00:00
Sumarigo-MSFT
47,101
Reputation points Microsoft Employee
1 answer
One of the answers was accepted by the question author.
How to use DIFFINDAYS function in calculated field in dataverse
I want to get the difference between today and another date time column in dataverse and put it into a column using calculated field but when I try to use DIFFINDAYS, it doesn't work. See below screenshot. Thank you in advance for your help!
asked 2024-10-27T03:45:02.8333333+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, 99%, 13%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECM%3C/text%3E%3C/svg%3E)
Charlie Matanguihan
25
Reputation points
commented 2024-10-30T12:00:14.13+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(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)
Kiran P
4,815
Reputation points Microsoft Vendor
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-21T08:43:23.5466667+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
11,295
Reputation points Microsoft Vendor
0 answers
Adding Dataverse to Copilot Studio as knowledge with authenticate manually
Hi Team, I have created a Copilot in Copilot studio, and added Dataverse as knowledge, authenticate manually was chosed, when I want to get answer from Datavers, it is no response. I noticed for Dataverse, the scope should be set as below, can you please…
asked 2024-10-21T03:03:57.4133333+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(224.00000000000003, 47%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EYD%3C/text%3E%3C/svg%3E)
Yu Dong (Accenture International Limite)
0
Reputation points Microsoft Vendor
asked 2024-10-21T03:03:57.4133333+00:00
Yu Dong (Accenture International Limite)
0
Reputation points Microsoft Vendor
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
7,710
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,890
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
phemanth
11,295
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
3,265
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,845
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
11,295
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://learn.microsoft.com/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,615
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,116
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,116
Reputation points Microsoft Employee