Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Export/Copy&Paste from Query to Excel Changes Data Values

Hi everyone,

 

I am trying to export a table from Power BI that has 263,000 rows of data. I have tried to export it via a visual and by copying and pasting. Each time the data values change.

 

I have even filtered the data to multiple different amounts of rows to sub 10,000, but it still will not export it correctly. Is there a reason it is doing this and a way to fix it?

 

For example I have a product that is originally 011355, but exporting it makes it 11355. Along with changing some products to random things like "Broken Box" or "Sur Total"

 

Thank you!

Need Help

1 Reply

  • v-xiaotang's avatar
    v-xiaotang
    Community Support
    5 years ago

    Hi Anonymous 

    the first question, " I have a product that is originally 011355, but exporting it makes it 11355"

    -

    what the type of [product]? pls change the type of [product] to text and test again.

     

    the second question, Along with changing some products to random things like "Broken Box" or "Sur Total" 

    -

    I've never encountered this kind of problem, could you please share the PBI file after removing sensitive information? and I'll test it later.

     

     

    Best Regards,

    Community Support Team _ Tang

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