A question about Data Model - SQL vs PBI

[Anonymous]

What do yout think what is better/faster in terms of data processing?

To create a measure in PBI desktop or if I have the chance - and I am using SQL to querying data - to create that measure and processing during the SQL data querying. 

[amitchandak · Accepted solution]

@Anonymous , All data preparation, and Calculated columns should be moved to the database and you should create a measure in power bi. If part of the measure in power bi can be created a column in database, move that to database or ETL

[amitchandak · Accepted solution]

@Anonymous , All data preparation, and Calculated columns should be moved to the database and you should create a measure in power bi. If part of the measure in power bi can be created a column in database, move that to database or ETL

[Anonymous]

Hi @amitchandak, 

Thank you for your answer, do you know any written article about this topic? I have started at a new company and I am trying to collect as much information as possible to reasoning, the problem that there are 20-25 tables in the reports and tons of measures and I want to really change this way, previously I had same issues (previous company) and we shovelled all data into one table as you wrote and I loved that. 

[v-easonf-msft · Accepted solution]

Hi, @Anonymous 

Hope this post is useful to you.

How to decide what you do in PowerQuery vs SQL 

Best Regards,
Community Support Team _ Eason

[Anonymous]

Thank you!