Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
5 years ago
Solved

Transform Data content and Data Viewer do not match

When you perform several steps in Transform Data, I verify that the data is correct to apply and close. Then I go to the data viewer of the main pane and the data is not the same. I transform data ag...
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Syndicate_Admin - The data in Transform data is just a representation of the data based upon the first 1,000 rows or so. Once you close and apply though, all of the data will be imported. 

  • Anonymous's avatar
    Anonymous
    5 years ago

    HI mambo7,

    I'd like to suggest you check these values to confirm if they exist in your table first.
    AFAIK, current power query table only shows the preview of the query steps processing result, it does not show all of your records. (it get some records as snapshot from your data source when you connect to the data source)

    If you want to keep raw table row structure, you can add an index column to your data source, then you can use this as sort order fields to keep raw orders.

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
5 years ago

HI mambo7,

I'd like to suggest you check these values to confirm if they exist in your table first.
AFAIK, current power query table only shows the preview of the query steps processing result, it does not show all of your records. (it get some records as snapshot from your data source when you connect to the data source)

If you want to keep raw table row structure, you can add an index column to your data source, then you can use this as sort order fields to keep raw orders.

Regards,

Xiaoxin Sheng