Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Custom Connector for PowerBi to enable limit clause support.
09-28-2023
06:32 AM
Hi Team,
I have designed a custom connector which supports native query, now I would like to add support for limit clause. I have done changes refering to this Parameters for the Odbc.DataSource function - Power Query | Microsoft Learn but I still dont see the Limit clause getting appended to the query I pass.
FYI:
Added this piece of code in .pq
AstVisitor = [
LimitClause = (skip,take) =>
if (skip > 0) then error "Skip/Offset not supported"
else
[
Text = Text.Format("LIMIT #{0}", {take}),
Location = "AfterQuerySpecification"
]
],
Could you suggest what changes needs to be added to make it work as expected.
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-02-2023
10:28 PM
Can someone please respond.

Helpful resources
Announcements
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
User | Count |
---|---|
6 | |
6 | |
3 | |
2 | |
2 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
6 | |
5 | |
4 | |
4 | |
3 |