Forum Discussion

eilalan's avatar
eilalan
Frequent Visitor
9 years ago

Big Table load

Hello,

 

I am trying to load the following table:

 

schema:

Details
Preview
sample_idSTRINGNULLABLE
Describe this field...
allele1XRefSTRINGNULLABLE
Describe this field...
allele1GeneSTRINGNULLABLE
Describe this field...
Table Info
Table IDpgp_variants_only_with_gene_and_dbsnp
Table Size43.5 GB
Number of Rows710,742,568
Creation TimeJun 6, 2017, 5:28:22 PM
Last ModifiedJun 6, 2017, 5:28:22 PM
Data LocationUS
LabelsNone

 

and have a memory failure message. Could you please let me know if I should be able to load large table to power bi. If yes, i will try to load it with stronger machine

 

thanks,

eilalan

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    1 GB limit as far as i know.  I'd look to writing an SQL statement to cut down the columns and only return what you need.  43gb is a bit big.

    • eilalan's avatar
      eilalan
      Frequent Visitor
      9 years ago

      this is a challenge for genomic data where explore many features (with filters / slicers / etc) to generate hypothesis.

      This was 3  columns table - a subset of a bigger table.

      I will try to see what can be done.

      if anyone knows of a walk around, please let me know.

       

      Thanks,

      eilalan