Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    4 years ago

    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's avatar
Anonymous
Not applicable
4 years ago

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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thank you!