Forum Discussion

adapodaneevera's avatar
adapodaneevera
Regular Visitor
8 months ago
Solved

Power Automate CSV output not updating when opened in Excel

Hi All, I created a flow in Power Automate that exports a CSV file to SharePoint. In the SharePoint file preview, I can see the correct and updated data. But when I open or download the file in E...
Need Help
  • Anonymous's avatar
    Anonymous
    7 months ago

    Hi adapodaneevera,

    This normally happens because the Excel file still contains some invalid values even though they are not visible. In Excel, values like N/A are treated as error values, not normal text, so Trim and Clean will not remove them. That is why Power BI still throws errors.

    Another common reason is that mobile number or pincode columns come from Excel as numbers or scientific format, and Power BI keeps switching the type in the background even after you change it to Text.

    Please try replacing errors with null first, then set the column type to Text, and only after that apply Clean and Trim. Also, if possible, set the column format to Text directly in Excel before loading it into Power BI.

    This is a data formatting issue from Excel, not a Power BI issue.

    Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
    Regards,
    Community Support Team.

Anonymous's avatar
Anonymous
Not applicable
7 months ago

Hi adapodaneevera,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.


Regards,
Community Support Team.


adapodaneevera's avatar
adapodaneevera
Regular Visitor
7 months ago
May I ask one more thing, please? When I load Excel files into Power BI, it automatically inserts a space before certain values. For example, after loading columns like Mobile Number or Pincode, I convert the data type to Text, handle the non‑breaking space (ASCII 160), then apply Transform → Trim, Transform → Clean, and finally replace "#N/A" with null. Despite this, I’m still getting errors. Do you know why this might be happening?
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 months ago

    Hi adapodaneevera,

    This normally happens because the Excel file still contains some invalid values even though they are not visible. In Excel, values like N/A are treated as error values, not normal text, so Trim and Clean will not remove them. That is why Power BI still throws errors.

    Another common reason is that mobile number or pincode columns come from Excel as numbers or scientific format, and Power BI keeps switching the type in the background even after you change it to Text.

    Please try replacing errors with null first, then set the column type to Text, and only after that apply Clean and Trim. Also, if possible, set the column format to Text directly in Excel before loading it into Power BI.

    This is a data formatting issue from Excel, not a Power BI issue.

    Hope the above provided information help you resolve the issue, if you have any further concerns or queries, please feel free to reach out to us.
    Regards,
    Community Support Team.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 months ago

    Hi adapodaneevera,
    I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

    Regards,
    Community Support Team.