Forum Discussion

AnandNamburi's avatar
AnandNamburi
Icon for Helper III rankHelper III
5 years ago
Solved

Import mode export data will load only 1.5 lac record?

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 impo...
Need Help
v-kkf-msft's avatar
v-kkf-msft
Icon for Community Support rankCommunity Support
5 years ago

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's avatar
AnandNamburi
Icon for Helper III rankHelper III
5 years ago

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's avatar
    v-kkf-msft
    Icon for Community Support rankCommunity Support
    5 years ago

    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's avatar
      AnandNamburi
      Icon for Helper III rankHelper III
      5 years ago

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

      • v-kkf-msft's avatar
        v-kkf-msft
        Icon for Community Support rankCommunity Support
        4 years ago

        Hi AnandNamburi ,

         

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

         

        Best Regards,
        Winniz