Skip to main content
Microsoft Idea

Power BI

New

Opening CSV exported data in Excel some characters are ouput with single quotation(')

Vote (11) Share
Muhiddin Kurbonov's profile image

Muhiddin Kurbonov on 30 Aug 2022 07:43:43

Export the created report data to CSV on the Power BI Service, and open the downloaded csv file in Excel and check it.

When cx opened the downloaded csv file in Excel or text, operators such as "+", "=", etc. have single quotes attached to them.


We know this is stated as limitation in thie following documentation as below.

Export data from a Power BI visualization - Power BI | Microsoft Docs

  • When you're exporting to .csv, certain characters will be escaped with a leading ' to prevent script execution when opened in Excel. This happens when:
  • The column is defined as type "text" in the data model, and
  • The first character of the text is one of the following: =, @, +, -



However, when other systems try to refer that data for further usage, they have data inconsistency error.


We would like to avoid that single quotation mark in CSV export/