Why Power BI

[lezawang]

Hi
I have been reading/watching youtube videos about Power Query and Power BI. I noticed that Power BI is basically = Power Query + Visualization
but if the visualaiztion is not important for a user then Power Query is enough, then why the need of Power BI.
I know PowerQ uses M langiage and Power BI uses DAX. I yet to learn about these 2 languages but what is the point of learning PowerBI
when I can use PowerQ. Thank you very much.

 

[Misca]

I'd say the difference between Power Query and DAX (be it Power BI or Power Pivot) is as roughly the same as the difference between a calculator and a spreadsheet software. Sometimes a calculator is all you need.

Power Query is an awesome tool. I love it and often times it's all I need. But if I need to add interactivity or time intelligence to my reports it's just not enough.

 

[XL Pro]

You'll also use DAX in Excel for Power Pivot