Power BI Salesforce Connector: Native vs Advanced Solutions

How the native connectors work, where their limits become critical, and when Metrica Power BI Connector for Salesforce becomes the better fit.