Export table without Data Sampling

[skoalit]

Hi, Is there a way to export the data over the limit without data sampling? Or is there any way to overcome the obstacle?

[MattAllington]

---

@skoalit wrote:

Hi, Is there a way to export the data over the limit without data sampling? Or is there any way to overcome the obstacle?

---

What do you mean "Export the data"?  You are normally importing data into Power BI, not exporting.  If you want to get data out of the data model eg if you have 5 million rows in a table in Power BI and you want to export to a CSV, you can use DAX Studio.

Read my blog here http://exceleratorbi.com.au/getting-started-dax-studio/  item 3 in the list

[BhaveshPatel]

Hmm.. Thanks Matt for putting a focus on this.

I will definitely recommend this to users next time as it is easy, quick and without any limitations. By the way, Your article on DAX Studio was great for new starters. 

[BhaveshPatel]

You can use Query editor to get Top 10000 Rows( Limit for CSV Export) for Query 1 and similarly create more than one Queries by adjusting the no. of rows wanted using Query Editor and Later on, You can copy/paste two different CSV Files. 

Lot of Manual work but have not seen any other option for really large tables.

You can try R script as well for data export(Limited to 150K rows). ( Please see this BLOG from ImkeF)

[skoalit]

Is it possible to export the table without having to choose the option of Data sampling? I knew it went over the limit, is it possible to overcome this obstacle through other ways?