What are the pros/cons of creating relationships in Power Query vs Power Pivot? I use Power Query to create relationships between my imported data sets. I know that Power Pivot has similar capabilities but I'm not sure what the difference is between using one or the other.