Forum Discussion

Chapin4u's avatar
Chapin4u
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Optimize refresh tme for 40 million rows

Hello community members, Need help to optimize refresh time for 40 million records and growing. Using the import method from an MS SQL server. Power BI desktop is located on the same server were imp...
Need Help
kcantor's avatar
kcantor
Icon for Community Champion rankCommunity Champion
9 years ago

Chapin4u

Another suggestion is to remove as many columns as possible and use lookup tables. As an example, When I first took over our transaction table, the rows had columns with the order date, order year, order month, and order week. I pulled all but the date and transferred everything else to the datedim table. The rows also had item number along with product cat, product lvl2 cat, product endleaf, and sub cat. I pulled those and related to an item table.

You may already be doing this but if not, it can reduce refresh time.

Chapin4u's avatar
Chapin4u
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Thanks for your suggestions, but if you don't mind me asking, how meany rows did your PBI report had and how much time were you able to improve by doing your suggestions. Thanks for your help.........