Forum Discussion

bojaboja's avatar
bojaboja
Frequent Visitor
2 years ago
Solved

Power Flow not exporting CSV table properly

Hello,

 

I have created a button in Power BI report that exports data to CSV, stores the document on the sharepoint and sends the document to the user. The document sent on the sharepoint displays data correctly in the table, unlike the document sent to the email inbox. What am I doing wrong?

Thanks

 

Here is the output

Sharepoint looking ok

Sharepoint Output     

Email not looking ok

 Email Output

 

 

 

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi bojaboja ，

    Opening text directly in Excel is scrambling because the file is a sequence of characters and does not contain data that must be interpreted like binary numbers.

    You can check out the encoding settings below

    Here's the test I tried:

    Best Regards,

    Xianda Tang

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

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi bojaboja ，

    Opening text directly in Excel is scrambling because the file is a sequence of characters and does not contain data that must be interpreted like binary numbers.

    You can check out the encoding settings below

    Here's the test I tried:

    Best Regards,

    Xianda Tang

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