Forum Discussion
BEST PRACTICE: How much data cleanup to do in DAX vs. Power Query?
Some things to consider:
- Most (everything?) you can do in PQ can be done via the PowerBI PQ GUI
- Does this enable more "citizen developer" productivity within your org?
- Is there PowerBI expertise within your org to maintain reports?
- Or does your org already use a MODERN ETL language?
- Is PQ (via PowerBI) a potential "upgrade" for your orgs existing (maybe antiquated/esoteric) ETL products?
hi eric
great question here
im trying to leverage the PowerBI expertise in my team, ive been assigned newly to it, currently we are using ODICS and ADW from ORACLE, the problem is alot of projects and cleaning is made from very old team and mostly are gone with no proper documentation, and this is affecting the performance but we can say its clean with not nulls so far
im trying to use more shared datesets and dataflows so i can spread self-service BI culture in the company and now im in the process to hire new candidate to handle more ETL work but having expertise in ODI is more available than PQ, so im wondering if its better to start using the PQ powers or keep it for special cases