Forum Discussion
Transformation in Power BI : Where ?
Dear Power BI users,
I have a big question which answers does not give me satisfaction.
What kind of data transformation should be done in :
- Power Query (Edit Query)
- Power BI
For example, i need to :
- create a new table
- create columns (concatenation, if, etc.)
- create measures
- filter data
- change format
Thank you,
:smileyhappy:
I agree with Anonymous .
Personally on my side, I am working more on power query than dax. Or maybe because I am still learning dax and I became comfortable using power query.
Downside of it is when you are using Direct query, you have limits in power query and dax is better to use.
For computations, dax is better.
Data trasforming, power query.
Depends on your needs. Both are awesome.
3 Replies
Hey Anonymous
As with most things in life, it depends.
Regarding measures, those can only be created in Power BI (PBI); however, you can create functions & conditions in Power Query (PQ).
Personally--as I've worked more with PBI--I've found myself doing as much as possible in PQ. I have found some articles/posts from various sources that indicate there are marginal speed/resource benefits to taking action in PQ as opposed to taking the same action in PBI. My models aren't large, but I figure if I learn how to do stuff in PQ now, it will pay off if/when my models become large.
- mussaenda
Community Champion
I agree with Anonymous .
Personally on my side, I am working more on power query than dax. Or maybe because I am still learning dax and I became comfortable using power query.
Downside of it is when you are using Direct query, you have limits in power query and dax is better to use.
For computations, dax is better.
Data trasforming, power query.
Depends on your needs. Both are awesome.