| Csv@1 |
CSV files |
no |
Only very limited SQL constructs |
| CsvOleDB@1 |
CSV files |
yes |
Advanced SQL, but driver needed |
| Dax@1 |
Tabular models (Power BI, SSAS) |
yes |
Requires queries in DAX, not SQL |
| Excel@1 |
MS Excel xlsx files |
no |
Only very limited SQL constructs |
| Excel@2 |
MS Excel xlsx files |
no |
Preview. Advanced SQL, no driver needed |
| ExcelOleDB@1 |
MS Excel xlsx files |
yes |
Advanced SQL, driver needed |
| MySql@1 |
data from any MySQL compatible DB |
no |
|
| Odbc@1 |
data from an ODBC source |
no |
|
| Oracle@1 |
data in ORACLE database |
no |
|
| Postgres@1 |
data in PostgreSQL database |
no |
|
| PowerBI@1 |
Open Power BI desktop file |
yes |
|
| Snowflake@1 |
data in Snowflake |
no |
|
| SqlServer@1 |
data in MS SQL Server database |
no |
|
| SqlServer@2 |
data in MS SQL Server database |
no |
Newer driver, supports e.g., service principals |
| Yaml@1 |
data in YAML files |
no |
|