Forum Discussion

eilalan's avatar
eilalan
Frequent Visitor
9 years ago
Solved

loading data - 2/3 columns are emply

Hi,   I am loading data from BigQuery. The data looks like the sample below,     At the preview step the data looks okay. after loading, only the sample_id is visible. any idea why?   Many th...
  • eilalan's avatar
    eilalan
    9 years ago

    Hi all,

    my bad.

    I played with the sort of the columns and was able to get data out of them.

    It is proably a default sorting that place the emply columns at the begining of the table.

    I am all set for now.

    Many thanks,

    Eila

vanessafvg's avatar
vanessafvg
Community Champion
9 years ago

eilalan are you referring to the counts?  if so you need to change your data type to number not text  or create a measure on top of it, or change the object  you are using to a table or matrix

eilalan's avatar
eilalan
Frequent Visitor
9 years ago

i added another image of the power BI(left) and the BigQuery (right) tables before loading.

the power bi shows only two columns out of the three of the bigQuery.

I am re-trying to load with this issue and will let you know what the result is.

Please let me know if you have any other idea

 

Thanks,

eilalan

  • eilalan's avatar
    eilalan
    Frequent Visitor
    9 years ago

    Hi all,

    my bad.

    I played with the sort of the columns and was able to get data out of them.

    It is proably a default sorting that place the emply columns at the begining of the table.

    I am all set for now.

    Many thanks,

    Eila