Forum Discussion
Force Query Join to be performed at the database?
No, you have to create your SQL Query and use it from your excel o PowerBI desktop.
Regards
That would be OK for me, but what about Business Users who do not know SQL? is there a built in SQL query builder inside Power BI that business users that do not know SQL can use?
The feature of pushing Power Query logic to the database server is called folding. Power Query is often doing a good job folding transformations back to the database, but we don't have a definitive guide from Microsoft as to what transformations will be folded and which ones won't.
It makes total sense to assume that two PQs from the same data source with no other transformations in them should be merged back at the database level when the users selects the Merge command, but there may be some technical issues that make this difficult from the implementation perspective.
