Implement Direct Query from REST API

[Anonymous]

Hi,

I'm following this walkthrough in order to create a connector so that I can perform Direct Query through Rest API. The last part of this step-by-step (This tutorial) show about implementation of sames handlers of Table.View but it does not show how to implement handlers to enable Direct Query as GetExpression and OnInvoke. This handlers is required to enable Direct Query. Another question, When I implement theses callbacks, How can I enable Direct Query to my Connector? And How can I test it?

Thanks!

[v-alq-msft]

Hi, @Anonymous 

I'd like to suggest you build  an ODBC driver for enabling Direct Query on Rest API. The only way that Power BI currently enables Direct Query is using Data Connector SDK provided by Microsoft for Power BI. The Data Connector SDK will allow you to enable Direct Query on ODBC driver only.

For further information, please refer to the document .

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

 Hi @v-alq-msft. Thanks for answer!

I always see this approuch in build an ODBC Driver to ODBC. I see specifically this tutorial (Progress) that It use a paid tool to create a ODBC through. But I can see on documentation that I can enable Direct Query through REST Api using a data connector, implementing same handlers of Table.View (GetExpression and OnInvoke).

Theses handlers I do not see on documentation and implementation about it.

How can I build a connector for this? No use ODBC Drive?

Thanks!