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. 

 

jasiluka Visitor
Visitor

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
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 374 members 3,660 guests
Please welcome our newest community members: