Anti Joins And Query Folding In Power Query In Excel And Power BI

Power Query allows you to merge (“join” in database terms) two tables together in a variety of different ways, including left and right anti joins. Unfortunately, as I found recently, anti joins don’t fold on SQL Server-related data sources, which can result in performance problems. Luckily there is a different way of doing anti joins… Continue reading Anti Joins And Query Folding In Power Query In Excel And Power BI
Published on:
Learn moreRelated posts
AI and Power BI | Time to act now 🚀
4 hours ago
Calendar STYLE Date Slicer in Power BI
2 days ago
Power BI – Paste List of Values into Slicer?!?
So it has been a bit since I have posted here. The balance of work and family life⚖️ So what is it that got me so excited this week that I jus...
2 days ago
Dynamic Pareto analysis in Power BI
3 days ago