Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Solved! Go to 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.
Proud to be a Super User!
@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
Proud to be a Super User! |
|
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.
Proud to be a Super User!
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
Proud to be a Super User!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
109 | |
108 | |
108 | |
91 | |
61 |
User | Count |
---|---|
171 | |
138 | |
132 | |
102 | |
86 |