Power Flow not exporting CSV table properly

[bojaboja]

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

[Anonymous · Accepted solution]

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.