Migrate dataverse table between tenants with different language settings

(0) Share

Report

Posted on by thebruuu

I am migrating dataverse data , as per dataverse migration documentation

I exported and imported a solution with table definitions

I used the wizard the create the powerautomate dataflow based on Odata connecter.

The Power query looks fine and data look ok...

But when i run the flow, the float/double typed data are multiplied x 1000 as if there was some locale issue...

Btw the source and target d365 environnements are not identical, as One has french as base language and the other One has french as base language...

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (0)

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Hello, @Bruno_C, what is the data types of your float/double typed data columns?

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

AhmedSalih

6,678 Moderator on at

Like (0)

Report

Hello, @Bruno_C, what is the data types of your float/double typed data columns?

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

Fubar 8,352 Super User 2025 Season 2 on at

Like (0)

Report

In your target environment check your Users personalization settings, under the Formats tab check the format of the Number and Currency to make sure it not just a display setting (rather than underlying data issue).

Was this reply helpful? Yes No
kuku 6 on at

Like (0)

Report

Nope, it's not a data visualisation issue as some import lines don't get imported because the number is too big (as it multiplies the original one by 1000)

Was this reply helpful? Yes No
thebruuu 15 on at

Like (0)

Report

@Fubar ; unfortunately it is not a visualisation issue:
Data get rejected because it doesn't fit in the column (cause multiplied by 1000).
Thank you

Was this reply helpful? Yes No
thebruuu 15 on at

Like (0)

Report

Hello,
In the PowerQuery, the type is number and what the value in the final step of the PowerQuery is 7528,00754
In the powerautomate/powerapps dataverse table screen, this is a Float : and the value stored is 752 800 754,00

Was this reply helpful? Yes No