Comments (4)
Yury-Fridlyand
commented on July 19, 2024
1
@dratasich @andybeaulieu,
I found an incompatibility between ODBC driver and PBI connector - the connector can't set the fetch_size parameter.
I made a private build for you of the PBI connector which sets fetch_size to 10 for all queries. Try using it and post your feedback:
OpenSearchProject#16.zip
from sql-odbc.
dratasich
commented on July 19, 2024
Any news? Any solution for this issue? How can we get all results, e.g., for a PowerBI dashboard?
from sql-odbc.
Yury-Fridlyand
commented on July 19, 2024
Hi @dratasich @andybeaulieu,
Sorry for the late response, I got unsubscribed from all ODBC tickets because they were moved to another repo.
I tested ODBC driver with a sample application and it supports pagination/cursor.
Unfortunately, OpenSearch SQL plugin does not support TOP option in SELECT clause. You are welcome to open a ticket - client's/customer's issues are more valued.
from sql-odbc.
dratasich
commented on July 19, 2024
Thanks @Yury-Fridlyand - we will try and come back to you!
from sql-odbc.
Related Issues (20)
- Power BI is getting an unexpected data type for date columns from the ODBC driver[BUG]
- [BUG] ODBC driver doesn't use SSL HOT 1
- [BUG] ODBC driver requires additional configuration to use AWS_SIGv4 authentication
- [BUG] PBI connector hides region input string (replaces by *)
- [BUG] ODBC driver ignores `Use SSL` flag and requires https:// prefix for SSL connections HOT 2
- [BUG] Tableau is incorrectly receiving non-null values as null from the ODBC driver HOT 3
- [BUG] OpenSearch ODBC driver installer conflicts with already installed OpenDistro ODBC driver
- [BUG]Aggregate functions in PowerBI fail HOT 2
- Documentation - fix maintainers list in SQL HOT 1
- Baseline MAINTAINERS, CODEOWNERS, and external collaborator permissions HOT 3
- [BUG] `fetch_size` is not supported in PBI connector
- [FEATURE] Support EC2 Instance Authentication HOT 1
- [BUG] Build for macOS is currently failing. HOT 1
- [BUG] Connection fails if server URL has slash in the end HOT 1
- [FEATURE] Support SSH tunnel with AWS_SIGv4 auth
- [BUG] Windows installer is missing files.
- Manual approval required for workflow run 5458110121: Release ODBC driver version 1.5.0.0 HOT 3
- [BUG] PBI connector: Connectivity issue HOT 1
- [BUG] Using Power BI with aliased indices HOT 1
- [2.12.0] Ensure compatibility for 2.12.0 default admin credentials changes HOT 3
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sql-odbc.