Forum Discussion

boullen's avatar
boullen
Frequent Visitor
2 years ago

Problem to export data through PA with data with many decimals

Hi,

 

I have created an table in Power BI, connected to an Power Automate button that's create an excel-table on sharepoint.

The majority of the data exports correctly, but the number values seems to differ betwen the rows, and it seems to be the ones with many decimals. 

I have tried to change all the data to correct format (currency), but it doesent help. Do you guys have an idea of the problem?

 

Desktop:

 

Power Automate flow:

 

Sorry for the Swedish naming in the flow. If you need the english translation please say 🙂

 

 

Need Help
Tips and Tricks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi boullen ,

     

    During my investigation I have found users in the past who have had similar experiences to you .
    The solution given by other forum users was:This may be caused by the regional settings you use, in which the decimal operator is most probably the comma, as opposed to the dot character.

     

    For original post, you may refer to:Solved: Importing decimal numbers on Excel - Power Platform Community (microsoft.com)

     

    Hope it helps!

     

    Best regards,
    Community Support Team_ Scott Chang

     

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

  • boullen's avatar
    boullen
    Frequent Visitor
    2 years ago

    Hi Anonymous  and thanks for answer.

     

    The weird part of this is that some rows is correct, and some dont. Se the imput data och exported data below:

    Input:

    You can se it even changes the format to text in some rows 😮