Diff between Data in PowerQuery and PowerBI Table view

[msn_kheirabadi]

Hello guys;

I import data from SQL tables and My last table in PowerQury is like this:

But the coloumn "tlp_casedone" changes to codes like this in powerBI table view after save and apply Transform data:

What is the reson and how can I ignore this changing?

It's worth to mention that there is a relation between codes and texts in database. For examples users enter "1" instead of entering long text like "FullService".

[Arash_Bhz]

Hi (Salam),

Please double check to make sure you are not doing any transformation in your steps on the column you specified, if there is no transformation try convert the clumn to text(I know it already shows as if it is text but explicitly doing it might fix some glitchs), then right click, transform, clean( and then also Trim). Hope fully this will fix the issue.

[v-venuppu]

Hi @msn_kheirabadi ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.

Thank you.

[v-venuppu]

Hi @msn_kheirabadi ,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[jennratten]

If 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.  

1. Go to the table view
2. Look at the Data pane
3. 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.

1. If it is a calculated table, when you click the table name
2. the DAX script will appear in the formula bar.

1. 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
2. The DAX script appears in the formula bar.

Please let me know if you have any other questions.

[msn_kheirabadi]

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!

[JamesLee94 · Accepted solution]

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.