Cannot load model DirectQuery error: DirectQuery may not be used with this data source

[SeerData]

Hi guys.

I'm trying to get the data through CData Airtable to Power BI. Other tables are working and loading except this one
Whenever I transform the data this error shows

We couldn't connect to your DirectQuery data source or internal model. Double-check that your server and database names are correct and that you have permission to access them.

DirectQuery error: DirectQuery may not be used with this data source - please consider moving to a supported data source or upgrading the SQL Server data source to the latest available version

We tried not using an SQL statement but the same error. 

Thank you in advance 🙂 

[Greg_Deckler]

@SeerData - You will probably need to talk to CData about that issue. Which of the scenarios listed are you trying to use regarding AirTable and Power BI?

https://www.cdata.com/drivers/airtable/powerbi/

[amitchandak]

@SeerData , You are using a custom connector. Please connect with the developer for the error.

refer if this can help

https://support.microsoft.com/en-us/help/4093226/fix-directquery-may-not-be-used-with-this-data-sour...