Forum Discussion
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 thenks for any hint
eilalan
| Row | sample_id | allele1XRef | allele1Gene | |
| 1 | hu089792 | dbsnp.107:rs3794207 | 10645:NM_006549.3:CAMKK2:INTRON:UNKNOWN-INC;10645:NM_153499.2:CAMKK2:INTRON:UNKNOWN-INC;10645:NM_153500.1:CAMKK2:INTRON:UNKNOWN-INC;10645:NM_172214.2:CAMKK2:INTRON:UNKNOWN-INC;10645:NM_172215.2:CAMKK2:INTRON:UNKNOWN-INC;10645:NM_172216.1:CAMKK2:INTRON:UNKNOWN-INC;10645:NM_172226.2:CAMKK2:INTRON:UNKNOWN-INC | |
| 2 | hu089792 | dbsnp.83:rs683202 | 387357:NM_001010923.2:THEMIS:INTRON:UNKNOWN-INC;387357:NM_001164685.1:THEMIS:INTRON:UNKNOWN-INC;387357:NM_001164687.1:THEMIS:INTRON:UNKNOWN-INC |
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
7 Replies
- prateekraina
Memorable Member
Hi Prateek,
yes.
I have uploaded it to my google drive
the data was retrieved from bigQuery (in my other reports, there was not any issue)
thanks,
eilalan
- prateekraina
- vanessafvg
Community Champion
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
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
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
