Answered

Create dataverse table from excel

(0) Share

Report

Posted on by standenman

Sorry I meant to put this one with my last question. So next is my quest to simply create a dataverse table from an excel file I go th "Tables, "new table", "table from external data". Seems to be no connection for excel offered.

So next I go to "import data from excel" where I am offered a bewildering selection of "entities" that make no sense, but certainly don't seem to point me to my excel file. So I click "learn more" and I am directed to an article about "Import or export data from Dataverse" No I am wanting to import data INTO not FROM dataverse.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (11)

Answers (1)

Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
@standenman ,

Import data from Excel allows you to import a file and map the columns to an existing table
Import data allows you to import a file using dataflows to import the rows. You can run the import to create the table and then delete the dataflow connection afterwards.

To import Excel data into Dataverse, you must have a table which already exists to run a bulk import. Either create the Dataverse table manually and then run the Import data from Excel option, or create a Dataverse table from an Excel file using dataflows.
------------------------------------------------------------------------------------------------------------------------------

If I have answered your question, please mark your post as Solved. Remember, you can accept more than one post as a solution.

If you like my response, please give it a Thumbs Up.

Imran-Ami Khan

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@standenman

What you need is to use here is data flows..

Please check link below to get you started:

https://learn.microsoft.com/en-us/power-query/dataflows/overview-dataflows-across-power-platform-dynamics-365

Was this reply helpful? Yes No
standenman 36 on at

Like (0)

Report
Copy link

Link copied!

Thank you Mira and Amik for your answers. So I have created a dataflow based upon excel file "MyTestExcel". I just went with all defaults. At the end, not any direction on where to do next. I look at tables and see I have a table "MyTestExcel" but it has no data.

Was this reply helpful? Yes No
Ami K 15,687 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@standenman please share a screenshot

Was this reply helpful? Yes No
Mira Ghaly 11,415 Moderator on at

Like (0)

Report
Copy link

Link copied!

@standenman

You will need to publish and refresh your data flow.

Was this reply helpful? Yes No
standenman 36 on at

Like (0)

Report
Copy link

Link copied!

The dataflow is published but still not table data.

Was this reply helpful? Yes No
standenman 36 on at

Like (0)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
standenman 36 on at

Like (0)

Report
Copy link

Link copied!

This is the error code I see when I try to refresh the datalow: "Error Code: Mashup Exception Data Format Error, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: DataFormat.Error: We couldn't convert to Number. Details: P01040159 (Request ID: 0cb57357-b5d4-4746-8e2d-cc9965593c18)."

Was this reply helpful? Yes No
Verified answer

standenman 36 on at

Like (0)

Report
Copy link

Link copied!

This is the error code I get when I try to refresh the dataflow: "Error Code: Mashup Exception Data Format Error, Error Details: Couldn't refresh the entity because of an issue with the mashup document MashupException.Error: DataFormat.Error: We couldn't convert to Number. Details: P01040159 (Request ID: 0cb57357-b5d4-4746-8e2d-cc9965593c18)."

Was this reply helpful? Yes No
standenman 36 on at

Like (0)

Report
Copy link

Link copied!

I have gone through every column in the excel file making sure format is either "number" or "text" as appropriate. Once in power query I can see the little icons in the column name cell indicating the correct data type. But each time I get the following error code: "
"

Was this reply helpful? Yes No