The BI Connector.config file holds advanced settings that control how BI Connector behaves — logging, row limits, HTTP timeouts, data types, failure notifications, and more. This article covers where the file is, how to open and edit it safely, every available setting, and how to apply your changes.
Majority of users don't have to make any changes as the default values in this file would work. For users who want a high-level of customizations can read this document and make the changes they need.
Where the file is located
The file is located here:
The file name is BI Connector and its type is Config (see the screenshot below).
Open the file as administrator
Right-click the BI Connector config file and open it as administrator.
Configuration settings
The file is plain text, with one setting per line in key=value format. For example:
LogLevel=11f
MaxRowsFetched=25000
SuppressSelectStar=1
Change only the values you need. The available settings are below.
| Key | Default | Valid values | What it does |
|---|---|---|---|
launchNewUI | 1 | 0 / 1 | 1 = use the new UI dialogs; 0 = fall back to the old configDSN() UI. |
LastUpdatedTime | (empty) | UTC datetime | Timestamp used to detect config changes and trigger a reload of the global config. |
httpTimeout | 15 | Positive integer (minutes) | Timeout for async HTTP data fetches |
IgnoreInvalidCert | 0 | 0 / 1 | 1 = skip SSL/TLS certificate validation (accept self-signed / invalid certs). |
SuppressSelectStar | 1 | 0 / 1 | 1 = rewrite SELECT * into an explicit column list. |
ReportRowLimit | 0 | 0 / 1 | 1 = enable a row cap on report queries using ReportRowLimitCount parameter |
ReportRowLimitCount | 1000000 | Positive integer | Row count cap used in when ReportRowLimit = 1. |
IgnoreEmptyTables | 1 | 0 / 1 | 1 = hide tables with 1 or fewer columns from the schema list. |
IsConfigInfoMovedToIni | false | true / false | Legacy one-time migration flag (registry -> ini); no longer used for runtime behaviour. |
NullDateValue | 1900-12-31 | YYYY-MM-DD (must parse and be 10 characters) | Value substituted for NULL dates (Power BI connector). |
IgnoreCatalogName | true | true / false | Power BI-specific: ignore the catalog name in table references. |
MaxRowsFetched | 25000 | Positive integer | Hard cap on rows per fetch. |
logRotationFreq | 7 | Positive integer | Days of old log files to keep before deletion. |
async | 0 | 0 / 1 | 1 = fetch capped number of rows; 0 = fetch without row limit. |
Save your changes and restart the service
After editing, save the file (in Notepad, File > Save, or press Ctrl + S).
Your changes take effect only after you restart the BI Connector service. Open the Windows Services app (search for Services in the Start menu), find the BI Connector service, right-click it, and select Restart.