Microsoft Dataverse Training

1 answer

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

Charlie Matanguihan 25

commented

Kiran P 4,350 Microsoft Vendor

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

Murali Ramasamy 5

edited a comment

phemanth 11,125 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

Noah Gilbert 26

commented

phemanth 11,125 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

Yu Dong (Accenture International Limite) 0 Microsoft Vendor

1 answer

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

Asyifa Tasya Fadilah 45

commented

Syed Saleem Peera 7,380 Microsoft Vendor

1 answer

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…

asked

Mike G 20

commented

AmaranS 6,805 Microsoft Vendor

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

Lohit Dacha 0

commented

Smaran Thoomu 16,640 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

Noah Gilbert 26

answered

phemanth 11,125 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

Vidhya Ramesh 0

edited a comment

NIKHILA NETHIKUNTA 2,950 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

Tony Fontanoz 0

commented

Pradeep M 3,830 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

Arquitectura Datos 0

commented

phemanth 11,125 Microsoft Vendor

3 answers

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

Pankaj Singh 20

commented

RACHAEL DSOUZA 0

2 answers

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

David Rosenthal 20

accepted

David Rosenthal 20

1 answer

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

Louis Roux 20

commented

Louis Roux 20

1 answer

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

Kvaratshelya, Vladimir 25

accepted

Kvaratshelya, Vladimir 25

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

Steven Cardella 0

answered

Darin Searcy 10

1 answer

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

Marco Koen 30

commented

Srinud 2,610 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

Sriram M 40

commented

Bhargava-MSFT 31,116 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

Sriram M 40

commented

Bhargava-MSFT 31,116 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

Sriram M 40

commented

Bhargava-MSFT 31,116 Microsoft Employee

Microsoft Dataverse Training

Filter

Content

37 questions with Microsoft Dataverse Training-related tags

How to use DIFFINDAYS function in calculated field in dataverse

Copy Dataverse data into Azure SQL using Synapse Link

ADF Data Flow Mapping shows 0 rows written to Dataverse sink

Adding Dataverse to Copilot Studio as knowledge with authenticate manually

How to fix "Error loading Control" in Dataverse Form view (on Power Apps)?

How to enable permissions to import local excel to dataverse with trial account

Power BI failing with Bulk Load failed error

Azure Data Factory with Dataverse Sink (mapping data flow) Upsert broken?

How to troubleshoot Azure Synapse Link failing to create/modify model.json

My trial tenant wont allow me to create an environment

Columns disappear when I extract data from dataverse using synapse

Azure Data Factory Insert error on Dataverse sink

Possible mistake in MS Learn content?

How do I open a sandbox account when the error is The user does not have a license that allows environment creation.

Some of the tables are not created with azure synapse link

Azure Synapse Link for Dataverse Has Fewer Fields than Export To Data Lake

Use Dataverse triggers and actions in Power Automate - where is the Innovation Challenge application?

Automating Table Activation and Deployment for Synapse Link in Dynamics 365 Dataverse

Automate the activation of required tables in the Synapse Link for dataverse

How to Automate Synapse Link Table Activation and Deployment Across Environments