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.

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
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)