Unanswered

exporting from Ms access yes/no column

(0) Share

Report

Posted on by diegomarino

128

i'm exporting my access tables to dataverse, but in every table that has a yes/no column i have the same problem: field not updateable.

I know that in dataverse there is yes/no column, where is the wrong?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (8)

Answers (0)

Sort by

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

Hello, @diegomarino , where are you getting "field not updateable"? is it in Power Query?

If my reply helped you, please give a 👍, & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

diegomarino 128 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks for the answer.
i just export table from access and after the exporting i get the message "not updateable"

Was this reply helpful? Yes No

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

@diegomarino, that is strange. Can you try to create a Dataflow and use the Microsoft Access Connector? Lets see if you can import your Access tables without an error this way.

If my reply helped you, please give a 👍, & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

diegomarino 128 on at

Like
a
(0)

Report
Copy link

Link copied!

i tried to load and link the DB but i got those errors

Was this reply helpful? Yes No

AhmedSalih

6,680 Moderator on at

Like (0)

Report

Copy link

Link copied!

@diegomarino , I don't understand the error. Can you please translate? Please refere to this documentation for more information for the process of migrating Data from Access to Dataverse.

https://support.microsoft.com/en-us/office/get-started-migrate-access-data-to-dataverse-013c8bab-7737-46ca-ad2e-892bbf26287d

Also, you might find this article useful:

https://techcommunity.microsoft.com/t5/access-blog/the-access-connector-for-dataverse-and-power-platform-is/ba-p/3354250

If my reply helped you, please give a 👍, & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

diegomarino 128 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks, i gave a read to that but i think my problem is not mentioned there, unfortunely.

the first pic tells:

an exception occurred: the on-premises data gateway could not be reached, which could be offline

the second (the part in italian):
1) an exception occurred:
2) You may need the 64-bit version of the access database engine provider to read this file type. to download the client software visit the following web site
(but i cannot open the link)

Was this reply helpful? Yes No
AhmedSalih 6,680 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@diegomarino, I am not sure about the 64-bit engine so you can download it from here https://www.microsoft.com/en-us/download/details.aspx?id=54920

Was this reply helpful? Yes No
diegomarino 128 on at

Like
a
(0)

Report
Copy link

Link copied!

thanks.
i just saw that rich text is not supported in dataverse, maybe it's not my solution then...
thanks for the help

Was this reply helpful? Yes No