Lost data between Power Query and Power BI

[Anonymous]

Hi Community, 

I have in Power Bi a table that has fields that contains lists.

To see the values in the table, I go to Edit Queries and open the Power Query. In the relevant column I click on "Expand to New Rows".

Then the name "List" changed to "Record", so I again click on "Expand to New Rows".

After that I expect to see the columns with the values. The values are shown in the column filter:

But in the column is shown a unique value (3.60002E+11)

When applying the changes to Power BI, the only value that is shown is 3.60002E+11, in the column and also in the filter

So all the data is lost.

This happens in several different columns.

What am I missing? How can I work with the original values?

Thanks!!

[Mariusz]

Hi @Anonymous 

You need to change the data type from Any (ABC123) to Whole Number (123) like below.

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[Anonymous · Accepted solution]

Hi Mariusz, 

It didn't worked by changing it to Whole Number, but it did worked if changing in to Text!!

Thanks a lot!!!

[Mariusz]

Hi @Anonymous 

Happy you managed to work it out.

Thanks
Mariusz