Big Table load

[eilalan]

Hello,

I am trying to load the following table:

schema:

Details

Preview

sample_id	STRING	NULLABLE	Describe this field...
allele1XRef	STRING	NULLABLE	Describe this field...
allele1Gene	STRING	NULLABLE	Describe this field...

Table Info

Table ID	pgp_variants_only_with_gene_and_dbsnp
Table Size	43.5 GB
Number of Rows	710,742,568
Creation Time	Jun 6, 2017, 5:28:22 PM
Last Modified	Jun 6, 2017, 5:28:22 PM
Data Location	US
Labels	None

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

[v-chuncz-msft]

@eilalan,

See link below for how to connect directly to the data source using DirectQuery.

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-use-directquery/

[Anonymous]

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]

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