Forum Discussion

AZJohnPowerBI's avatar
AZJohnPowerBI
Helper I
2 years ago
Solved

Excel versus Power BI

Should I clean and model the data in Excel or keep it as a flat file and do everything in Advanced Query Editor in Power BI?
Tips and Tricks
Tutorial Requests
  • _AAndrade's avatar
    _AAndrade
    2 years ago

    Hi AZJohnPowerBI,

    Best practice says that we should make our data transformations as close to the source as possible, but It could depends the data trnaformations that you preformed and how you will schedule the refresh of this excel file.

_AAndrade's avatar
_AAndrade
Resident Rockstar
2 years ago

Hi AZJohnPowerBI,

Best practice says that we should make our data transformations as close to the source as possible, but It could depends the data trnaformations that you preformed and how you will schedule the refresh of this excel file.

  • _AAndrade's avatar
    _AAndrade
    Resident Rockstar
    2 years ago

    Hi AZJohnPowerBI,

    Did it solve your problem?
    Did my message help you in any way? If it did, please mark my message as the solution and give it a "kudo", I'll appreciate it and help me out