Hi
I'm currently working to translate current views in SQL, made from D365 FO tables (on-prem) into entites for our transition to cloud instance.
Normally, I would create entities, get their data in Power BI, make joins and get the desired results.
Would it be possible to make joins within an entity created, say 7 datasources, so it may save processing time in Power BI?