loading data - 2/3 columns are emply

[eilalan]

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

[vanessafvg]

@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]

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 · Accepted solution]

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

[prateekraina]

Hi @eilalan,

Can you share the pbix?

Prateek Raina

[eilalan]

the issue is not at the visualization part. I am still trying to resolve the data part.

the table look like the image in this link (2 columns are empty) 

please let me know if you have any idea.

Thanks,

Eila

[eilalan]

Hi Prateek,

yes.

I have uploaded it to my google drive

folder link

pbix link

the data was retrieved from bigQuery (in my other reports, there was not any issue)

thanks,

eilalan

[prateekraina]

Hi @eilalan,

Sorry not able to figure out.