Custom Connector Power BI REST API Direct Query Support

[rupest]

Hi,

We are developing a custom connector to fetch data from REST API. Our REST API is capable of handling complex queries generated from Power BI. For our connector we would like to enable direct query capabilities. we would like to know how we can delegate the queries generated by Power BI to our REST API via custom connector.

One of the option we found is using Table.View to implement query folding. We learnt that we need to implement different handlers for Table.View, but we are not sure which all handlers to implement and how? Specifically GetExpression and OnInvoke() handlers.

How we will get queries generated by Power BI and how should we implement this?

[v-qiuyu-msft]

Hi @rupest, 

You can take a look at this similar thread: https://github.com/microsoft/DataConnectors/issues/246

If you have further question, please post a new thread here. 

Best Regards,
Qiuyun Yu