cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sz4C Frequent Visitor
Frequent Visitor

Re: Export error: "Your data is too large. Some data sampling may occur."

I agree.  30K is too low.  Since there are a little over 40,000 zip codes in the US, this limitation means that you can't export data that has been aggregated at the zip code level (which MANY business people do).  This is a severe limitation in my book.

leinad13 Frequent Visitor
Frequent Visitor

Re: Export error: "Your data is too large. Some data sampling may occur."

It's a bit of joke this 'issue' as its not an issue at all - its a limit, implemented intentionally by microsoft in order to try and get you to export your data to their cloud! Why don't Microsoft put a note near the PBI Desktop download saying that there are limits on data export. No-one expects to be limited what data you can export, other than by your own hardware.

Highlighted
GTASTEVE Visitor
Visitor

Re: Export error: "Your data is too large. Some data sampling may occur."

This workaround will create chunks of 20k lines which can be exported.

 

1) add an index column to your table called "index"

2) add a new column named "EXPORT_GROUP" to your table (in the example below change TblName to your actual table name) :

 

EXPORT_GROUP = switch (true(),

AND(TblName[Index]>=0, TblName[Index]<=20000), "Group1",

AND(TblName[Index]>=20001, TblName[Index]<=40000), "Group2",

"Group3")

 

you can now create a slicer for the EXPORT_GROUP and export your data in sections. Add more Groups if you have a more than 60k of lines.

 

jestevez Frequent Visitor
Frequent Visitor

Re: Export error: "Your data is too large. Some data sampling may occur."

The easiest way is by using DAX Studio https://daxstudio.codeplex.com/

 

1. Connect DAX Studio to your Power BI

2. Type EVALUATE yourtable

3. Click Output  --> File

4. Run

 

PS. works for more than 1M rows

Captura1.PNG

 

 

 

 

 

 

jschlereth Member
Member

Re: Export error: "Your data is too large. Some data sampling may occur."

@amir_tohidi,

This idea seems like it pertains more to your posting: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/31837054-don-t-limit-download-dat...

 

I'm running into the issue too and the data isn't even that big. Frustrating.

 

dmgdotnet Regular Visitor
Regular Visitor

Re: Export error: "Your data is too large. Some data sampling may occur."

I got around this by publishing to my workspace and exporting (summarized data) from there and it worked successfully.  We are using live connection to SSAS though so not a difficult option for us to do it this way.

VijayReddy Frequent Visitor
Frequent Visitor

Re: Export error: "Your data is too large. Some data sampling may occur."

@jestevez

 

Hi,

Would you know if this is a reliable tool?

Yemeng_Hu Frequent Visitor
Frequent Visitor

Re: Export error: "Your data is too large. Some data sampling may occur."

Use DAX studio. 

 

Had a same problem before, resolved with DAX studio, at least for my project. 

 

Yemeng_Hu Frequent Visitor
Frequent Visitor

Re: Export error: "Your data is too large. Some data sampling may occur."

Use DAX studio. 

 

Had a same issue before, resolved with DAX studio, at least for my project. 

 

Anonymous
Not applicable

Re: Export error: "Your data is too large. Some data sampling may occur."

hi guys, DAX studio seems to work only with a tables in Query Editor?

 

What if i want to export 50k rows from a matrix table object that i have created? It merges some columns from different tables and uses measure as a value as well. Is there a way to export it ? 

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors