Forum Discussion
Diff between Data in PowerQuery and PowerBI Table view
Power Query shows your data as it is during the transformation steps, while the Power BI table view shows the final data after all transformations and model relationships are applied. So differences are normal, especially if you have filters, calculated columns, or measures in the model.
Super UserIf the first screenshot is showing the Power Query table that is being loaded to the model after all Power Query transformations are applied and the second screenshot is showing a table in the data model, then I think what you are seeing is a calculated table. If it were a calculated column added to the same table as snip 1 then it would have a different column name, but it is the same.
To investigate further, see the steps below which align with the numbered items in the snips.
- Go to the table view
- Look at the Data pane
- Does the table name for snip 1 and 2 match? I'm thinking not. For the table in snip 2, what does the icon look like? Contacts is a table being loaded from Power Query. Dates is a calculated table created with a DAX script.
- If it is a calculated table, when you click the table name
- the DAX script will appear in the formula bar.
- A calculated column has an icon that looks like the snip below, which is showing a calculated column added to to a table loaded from Power Query (you can also add a calculated column to a calculated table). When you click the column name
- The DAX script appears in the formula bar.
Please let me know if you have any other questions.
Thanks for your response,but it's not a calculated table or coloumn. there is just difference between showing form of data in last step of power query and what is loaded to data model! I don't know how come!
