Forum Discussion

Tom_Y's avatar
Tom_Y
Icon for Advocate II rankAdvocate II
2 years ago
Solved

Excels files --> SQL --> Power BI

Hi all, it may be off topic here, but this's where I learn all the Power BI.   We're small company, say 5 teams, each 5 projects, and each projects 3 excel files (75 excel, not csv). Each excel has...
Need Help
  • lbendlin's avatar
    lbendlin
    2 years ago

    The general question here seems to be - can Excel handle the potential growth in data size, how safe it is to continue using Excel (think data loss due to human error) and is it possible to improve your process by using SQL as the system of record for both Excel and Power BI.  So your title should say "Should I replace Excel sources with SQL sources?"

     

    Absolutely. But yes, it will require upskilling. You will have to decide if that is something your company is willing to do.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

The general question here seems to be - can Excel handle the potential growth in data size, how safe it is to continue using Excel (think data loss due to human error) and is it possible to improve your process by using SQL as the system of record for both Excel and Power BI.  So your title should say "Should I replace Excel sources with SQL sources?"

 

Absolutely. But yes, it will require upskilling. You will have to decide if that is something your company is willing to do.