Showing results for 
Search instead for 
Did you mean: 
Arktan Frequent Visitor
Frequent Visitor

Union Nested Tables in Custom Connector

Hi Folks, I've created a custom connector which pulls data over a REST API. Let's say the API exposes two endpoints, Departments and Events, where there are 10 departments and 100 million events per department. As an end user of the connector, I will only be interested in perhaps three of the 10 departments' events so I would rather not import a billion events just to post filter them. The Events endpoint does permit filtering by Department.


I'm using a nested navigation table to allow selection of the desired Departments' Events data, and while this achieves the goal of limiting the data retrieved, I'm left with one Event table per Department. Is it possible for the connector to union these nested tables into a single Events table? Sure, the user can easily do that using the PQ Editor, but I'd love to make it even easier for them. Likewise, I'd like to provide the filtered list of Departments from their previous (navigation) selections. Easy to do in PQ using references and joins, but I'm stumped how to achieve this entirely within the connector (if it's even possible).

Helpful resources

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 6 members 872 guests
Please welcome our newest community members: