Forum Discussion
Should I use Power Query/Power Pivot or "basic" tables and formulas?
Hello, I am making a business case and are unsure about the best general approach: "basic" tables and formulas with accompanying "simple" charts, Pivot tables and Pivot Charts, Power Query, Power Pi...
SergeiBaklanThank you! You're probably right. I think I'll go with Power Query to extract and clean the necessary data from the original SQL export, and then continue with standard formulas (not Power Pivot).
I'm not sure how familiar you with Power Query, just take into account you may use embedded SQL query, but with this you lost query folding. What's better to use depends on concrete situation.