Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
3 years ago

Performance PowerBi. What is the most optimal?

Good afternoon community. I have some doubts regarding the performance with 3 custiones. 1- What is the best performance with respect to the ETL part? I understand that to do data cleaning in ...
Migasuke's avatar
Migasuke
Icon for Memorable Member rankMemorable Member
3 years ago

Hi Syndicate_Admin ,

1. If you can - prepare data in the source. If your data source is a database, you can also take advantage of query folding - basically you do all your steps in Power Query, but they are automatically prefiltered on the side of the database. Check more here:
https://learn.microsoft.com/en-us/power-query/power-query-folding

2. Difficult question. If you know you might querry the same data multiple times in different reports, it might have sense to prepare some Dataflow, which stores all your data and you don't overhwelm your database. If the SQL queries pull different data I would skip Dataflow.


3. Can you provide some printsreen of model or desired outcome?