Import mode export data will load only 1.5 lac record?

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

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.