cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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.

Highlighted
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
New Member

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.

 

Highlighted
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

 

 

 

 

 

 

Highlighted
Advocate IV
Advocate IV

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.

 

Highlighted
Advocate I
Advocate I

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.

Highlighted
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?

Highlighted
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. 

 

Highlighted
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. 

 

Highlighted
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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Upcoming Events

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Top Solution Authors
Top Kudoed Authors