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 ...
As I understand it you only need it for table valued functions. CTEs are convenience constructs for subqueries, and joins work (mostly) the same way as applies.
I don't understand your response, I need to convert the query above to powerbi, there are other ways of doing apply type functions, but neither work with power bi in the format of the query.