Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Data lost between Power Query and Power BI

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 "Expa...
Need Help
  • HotChilli's avatar
    HotChilli
    7 years ago

    You haven't got the correct data type on the column.

    It is set as the 'any' type and when it gets brought into powerbi, the data is treated like text so the scientific notation is shown in powerbi.

     

    Experiment in Power Query with 'whole number', or 'decimal'

    If none of them work, just bring the original field e.g, 36003466347734 through as text and change it in power bi front end

HotChilli's avatar
HotChilli
Community Champion
7 years ago

You haven't got the correct data type on the column.

It is set as the 'any' type and when it gets brought into powerbi, the data is treated like text so the scientific notation is shown in powerbi.

 

Experiment in Power Query with 'whole number', or 'decimal'

If none of them work, just bring the original field e.g, 36003466347734 through as text and change it in power bi front end

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Worked!

Thanks!