Forum Discussion
Remove rows based on another table
Chavas , In most of the connection, you have an advance option, you can give a query there. so add this query using new connection route
Chavas - Oh, you are in Power Query, sorry, those commands I mentioned are DAX. Well, in Power Query, did you try the Left-Anti or Right-Anti joins? Let me look at this with a fresh set of eyes.
Thank you both ( Greg_Deckler and amitchandak ) for your assistance, what I am trying, it is something like this
SELECT TaskID, DATABASE.dbo.Ticket.TicketID, DATABASE.dbo.Ticket.Status FROM DATABASE.dbo.Task
inner join Database.dbo.Ticket on DATABASE.dbo.Task.ParentID=Ticket.ID
WHERE Ticket.Status != 'Closed'
So I have already filtered the Ticket table but I wont to prevent loading tons of rows which I do not need and I am not going to use it. So I do not need to have on a new table all the info of the Tickets, you know? I would like to keep it separated and then I will manage it through the relations.I might posted it in the wrong forum :S And sorry for the confusion
Chavas , In most of the connection, you have an advance option, you can give a query there. so add this query using new connection route
Yay!
That is a solution!
But the problem is that I have to hardcode the status in the query. In a future, If I want to change it, I will need to redo the query or minding that I have hardcoded somewhere.Is there any other fancy/more elegant option?
(I am quite new to PowerBI, so your solution might be the way)