Forum Discussion

primolee's avatar
primolee
Icon for Helper V rankHelper 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!

MNedix's avatar
MNedix
Icon for Solution Sage rankSolution Sage
2 years ago

Hi,

Why don't you export or copy/paste the data in a .CSV file and import it in Power Query? Then, then year after, you can do the same and simply append the new file to the old one (thus also keeping the old information for analytics purposes).

 

If this solved your problem then please mark it as the solution so others can see it.