Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Best Practice: Combine data using Power BI or SQL statements?

Hi,   I'm relatively new to Power BI, dablling for about a year, seriously using for about 6 months. I've created many reports, but only 4 at this time that are useful and utilized. Now that I have...
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    In general, the more that you can push back to the server the better. This is a general rule. So, creating a View in Postgres that does is simply a UNION of your two other views is going to be the most efficient. You have those options in Power BI because most end users do not have access to the backend SQL database, but if you do, then that is generally the "best" way of doing it.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
8 years ago

In general, the more that you can push back to the server the better. This is a general rule. So, creating a View in Postgres that does is simply a UNION of your two other views is going to be the most efficient. You have those options in Power BI because most end users do not have access to the backend SQL database, but if you do, then that is generally the "best" way of doing it.