Currently, fetch_size can be configured in ODBC by adding ;fetchSize=x block in the connection string.
PowerBI connector has no option to set this.
What is the expected behavior?
One of:
Update PBI connector: allow user to optionally set fetch_size and use it in connection string if set
Update ODBC driver to properly comply with ODBC API. For example, if SQLSetStmtAttr called with SQL_ATTR_MAX_ROWS, driver doesn't set fetch_size parameter. Maybe PBI connector update is also required.
What is the bug?
Currently,
fetch_sizecan be configured in ODBC by adding;fetchSize=xblock in the connection string. PowerBI connector has no option to set this.What is the expected behavior?
One of:
fetch_sizeand use it in connection string if setSQLSetStmtAttrcalled withSQL_ATTR_MAX_ROWS, driver doesn't setfetch_sizeparameter. Maybe PBI connector update is also required.What is your host/environment?
main@ 1f0620fb1Do you have any additional context?
Inspired by #16