Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
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 🙂
@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/
@SeerData , You are using a custom connector. Please connect with the developer for the error.
refer if this can help
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 23 | |
| 20 | |
| 18 | |
| 14 |
| User | Count |
|---|---|
| 58 | |
| 51 | |
| 41 | |
| 30 | |
| 24 |