Forum Discussion

primolee's avatar
primolee
Helper V
2 years ago
Solved

How to quickly manually enter data table with million rows

Hello everyone,   I have a fix data that won't change for a year but contains more than 1 million rows.  I don't want to store it in any kind of data sources such as database or sharepoint files be...
Need Help
  • primolee's avatar
    primolee
    2 years ago

    Reason not to import it from DB or csv is because data in this table only changes once a year, i want to minimize server loading of both BI Service and SQL server as much as possible.  I don't want the refresh time in Power BI Service taking too long because of this table.

     

    I just found out a way by reading it from csv file

    first at desktop, then turn off "include in report refresh".

     

    This way that table will not take any time or any loading at all afterwards.

     

    Thanks everyone!

Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi primolee 
You can directly export the data if it is in excel or CSV.

Why are you copy and pasting in the grid of power bi desktop .

 

Try this 

 

 

I hope you dont have to manually enter the data if you have data available in any of the given datasource format..

 

 

primolee's avatar
primolee
Helper V
2 years ago

Reason not to import it from DB or csv is because data in this table only changes once a year, i want to minimize server loading of both BI Service and SQL server as much as possible.  I don't want the refresh time in Power BI Service taking too long because of this table.

 

I just found out a way by reading it from csv file

first at desktop, then turn off "include in report refresh".

 

This way that table will not take any time or any loading at all afterwards.

 

Thanks everyone!