Katsu

My feedback

  1. 2 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    1 comment  ·  Power BI Ideas » Desktop  ·  Flag idea as inappropriate…  ·  Admin →
    Katsu commented  · 

    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や他のシステムに取り込むとカンマがデリミタとして利用されてしまいます。(他システムでは下記のようになります。)

    Parts ID | Parts Name | Price
    ----------------------------------------------------------------------------------------------
    P0000001 | Cover | $100
    ----------------------------------------------------------------------------------------------
    P0000002 | Component | A | $5
    ----------------------------------------------------------------------------------------------
    P0000003 | Component | B | $3

    ですのでTSV形式の出力機能が必要です。

    ExcelのPowerQueryやPowerPivotを利用する時はExcelのTSV出力機能を利用することで実現できています。

    Katsu supported this idea  · 
  2. 631 votes
    Sign in
    (thinking…)
    Sign in with: facebook google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    Katsu supported this idea  · 
    Katsu commented  · 

    This is great idea. If we can receive notification mail to system administrator group address, it would be better.

Feedback and Knowledge Base

Ready to get started?

Try new features of Power BI today by signing up and learn more about our powerful suite of apps.