Import mode export data will load only 1.5 lac record?

[AnandNamburi]

When we export the data using the more options from a power bi report in import mode do it will export only 150000 records?

If it is yes do we have any workaround to export all data. I';m using import mode and visual display is text table.

Thanks,

Anand

[v-kkf-msft]

Hi @AnandNamburi ,

In Import mode, you can export up to 150,000 rows of data.

If you want to export data overcome the limit of 150k rows, please try the following ways.

1. Runing R Script.

library(RODBC)
conn <- odbcDriverConnect("driver=SQL Server;server=.\\SQLEXPRESS;Database=MyDataBase")
odbcClearError(conn)
sqlSave(conn, dataset, tablename="MyR_table",rownames=FALSE, safer=FALSE, append=FALSE)
close(conn)

2. Using the Daxstudio.

                  

• Change the output to file:

     

• And run the following code:

EVALUATE 'MyTable'

     

• And save the file in the desired output.

     

3. Using the Analyze in Excel feature.

Creating Excel “Data Dump” Reports From Power BI 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AnandNamburi]

Hi When I tried through DAX studio, the file is getting downloaded but when I try to open it it was giving an error like the file was deleted/renamed like this.

Do you have any idea why I'm getting this error.

[v-kkf-msft · Accepted solution]

Hi @AnandNamburi ,

I could not reproduct your problem, here are the steps I took.

1. Download DAX Studio portable version and unzip it. Open the PBIX file and DAX Studio application.
  DAX Studio v2.16.2 (portable)       

2. Connect to the PBIX file.

 

3. Change the output to a file.

4. Query.

5. Save the output file. Make sure you have successfully exported the file.

Best Regards,
Winniz

[AnandNamburi]

After evaluate what I need to write, is it my workbook name or table name?

[v-kkf-msft]

Hi @AnandNamburi ,

Has your problem been solved? If it is solved, please mark a reply which is helpful to you.

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.

Best Regards,
Winniz

[v-kkf-msft]

Hi @AnandNamburi ,

You need to write the name of the table where you want to export the data.

Best Regards,
Winniz

[amitchandak]

@AnandNamburi , You can try python way

https://www.thebiccountant.com/2018/12/29/export-data-from-power-bi-to-csv-using-python/

https://pawarbi.github.io/blog/powerbi/python/sql/export/2020/06/23/export-powerbi-sql-python.html