Excel versus Power BI

[AZJohnPowerBI]

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?

[bhanu_gautam]

@AZJohnPowerBI , It depends on your use if it is one time use case you can do in excel also, but if you need to make changes dynamic than you should use Power Query so that if any change in data in case it is increased changes will get captured in Power Query

[_AAndrade · Accepted solution]

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]

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