Forum Discussion
Inner Join with Direct Query without pulling all data to client
Hi, I'm using Direct Query to Oracle db If I just add 1 table, PowerBi does not load all the data to client for the reports to work (applies filters and aggregations on report refresh). H...
Anonymous , have you used +0 in measure or crossjoin.
Have you used bi-directional joins?
refer to this
https://guyinacube.com/2019/01/30/power-bi-query-reduction-when-using-directquery/
https://community.powerbi.com/t5/Desktop/Query-Reduction/td-p/964484
Hi amitchandak ,
thank you for responding.
I'm not using any meassures or crossjoins. And DAX joins seem to only work on equivalent structure tables (not my case)
bi-directional joins seem to have no effect on merge query creation, likewise reducing query. They all seem to only have influence after the data is filtered.
Note that I can't even create the merged query because PowerBi seems to be overloaded with data.