Forum Discussion
Solved
Write your own SQL query vs views vs table imports
I am trying to optimize my future models. Previously, I have been writing my own queries joining tables, making aggregates, etc. I have since learned that I lose out on the built in query foldin...
EnrichedUser
Is always recommended to do all your ETL at the source level and bring in the data to PBI. Creating Views is the best option as per your case. It will enable Query Folding and Incremental Refresh as well.
EnrichedUser
Is always recommended to do all your ETL at the source level and bring in the data to PBI. Creating Views is the best option as per your case. It will enable Query Folding and Incremental Refresh as well.