Forum Discussion
SQL outer apply with top 1 table
Hi Is there a way to convert this query for the service? It works well on the Desktop version but not in the service declare @From date declare @to date SELECT t1.*,t2.*,t3.* FROM Fact f ...
I don't see any functions. You should be able to do the same with a standard left join.
These are table expressions being joined, so PBI needs to dynamically filter the apply expressions at run time for top 1's. It's not the same as a LEFT JOIN to a table