Unable to get Dynamics 365 Business Central Query connector working when there are multiple companies in the org

I'm currently testing out this connector with a third-party vendor who manages the Dynamics 365 org. The connector works when there is only one company in the org since it chooses the default company. However, it does not work when there are multiple companies in the org. I tried filling in the 'Company Name' explicitly, it finds the data sources but does not fetch any data, although there is data present in those endpoints.

 

Any help on how I can get around this, would be appreciated?

 

Thanks