You’re offline. This is a read only version of the page.
Hi I'm new to Dataverse and I'm having issues trying to load data into Dataverse table using sql database as my data source. The process overall seem fairly straightforward as I'm able to connect to my preferred database and when I navigate to the Power Query page of the setup I'm able to see the query executing fine without an incident. On the next page, "Map Table", I'm asked to pick a Unique primary name column when I select a field that has unique set of numbers and doesn't duplicate. The field type is a whole number, however, when I set it as Unique primary name column it changes to a text field. When I proceed to the next page where I set the frequency of data refresh and publish the table, I get a msg that reads "There was a problem refreshing the dataflow. Please try again later. (Request ID: e413a7fb-0f10-4180-8cce-f0c40e7c8538)." Has anyone come across this and how did you resolve it?
I should mention that I did another one where I'm setting the "Unique primary name column" field as ""autogenerate". This did not work either and also produced the same error msg.
In PowerApp when I navigate to "Tables" I can see the table but it's basically empty but has the headers of the sql db that I'm attempting to pull...
So what I think is happening is that you are using your SQL unique id but what Dataverse is expecting is a GUID. That’s dataverse’s primary key field so it’s probably looking for that format so it makes sense it forces it to a text field. The option to auto-generate is probably what you want, and map your ID to another field that is whole number. That can probably also be defined as an alternate key to ensure uniqueness. If you continue getting errors open up the dataflow created and view details of the run. It should give you more detail as to why it failed.
Share
Report
All responses (
Answers (
2,189
