on 08 Jan 2019 14:20:08
I want Power BI (Service and Desktop) to add export function to TSV file.
Background
==========
Power BI's visual is very good, so I would like to make use of Power BI.
I want to export and use visual data, but in the CSV file the display collapses when importing to another system.
Therefore, it is necessary to export to TSV to utilize the exported data.
- Comments (1)
RE: Exporting Data from Power BI Desktop to TSV
'I would like to type in both English and Japanese to be easy to understand for Japanese engineer and increase PowerBI users in Japan.
日本のエンジニアに読みやすくしてPowerBIの日本のユーザーを増やすために和英併記で入力します。
(English)
When we get below comma included data to PowerBI, there is no problem in PowerBI display.
Parts ID | Parts Name | Price
----------------------------------------------------------------------------------------------
P0000001 | Cover | $100
----------------------------------------------------------------------------------------------
P0000002 | Component , A | $5
----------------------------------------------------------------------------------------------
P0000003 | Component , B | $3
But if we export such data to csv files and import to Excel or other systems, comma character is used as delimiter in other systems.
(see below sample)
Parts ID | Parts Name | Price
----------------------------------------------------------------------------------------------
P0000001 | Cover | $100
----------------------------------------------------------------------------------------------
P0000002 | Component | A | $5
----------------------------------------------------------------------------------------------
P0000003 | Component | B | $3
Therefore we need tsv export function in PowerBI.
We can export tsv files by Excel when we use PowerQuery or PowerPivot in Excel.
(Japanese)
下記のようなカンマが含まれているデータをPowerBIにロードしたとき、PowerBI内での表示上はまったく問題ありません。
Parts ID | Parts Name | Price
----------------------------------------------------------------------------------------------
P0000001 | Cover | $100
----------------------------------------------------------------------------------------------
P0000002 | Component , A | $5
----------------------------------------------------------------------------------------------
P0000003 | Component , B | $3
しかしながらCSV形式で出力した後でExcelや他のシステムに取り込むとカンマがデリミタとして利用されてしまいます。（他システムでは下記のようになります。）
Part