Forum Discussion
A question about Data Model - SQL vs PBI
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.
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
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
4 Replies
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
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.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