Forum Discussion

Manfredg's avatar
Manfredg
New Member
1 year ago
Solved

Loading Excel or CSV into Dataverse

Hello, I try to load an excel with about 1 mio lines into dataverse - the setting is in Dataverse to german number formats. The excel is set to german formats too. when i load the excel into dataver...
Need Help
  • v-veshwara-msft's avatar
    v-veshwara-msft
    1 year ago

    Hi Manfredg ,

    Thank you for reaching out to the Fabric Community.

    Based on your description, the issue appears to be related to Microsoft Dataverse and how it handles number formats during data import. Since Dataverse is part of the Power Platform, the best place to get specialized support would be the Power Apps Community – Dataverse Forum:

    Microsoft Power Platform Community Forum Thread

     


    Hope this helps. Pleas reach out for further assistance.
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and a kudos would be appreciated.

     

    Thank you.

     

     

     

Manfredg's avatar
Manfredg
New Member
1 year ago

p.s. if i enter a value manually in a float field it accept 14,17 !!!

AND text is not i option i prefer because of the calculation afterwards in power apps - it's the a nightmare allways convert every field

Manfredg's avatar
Manfredg
New Member
1 year ago

the power query function within the dataload is set to german too - i just checked - but it still loads in dataverse us-english format