Tutorials for making custom connectors for ODBC SQLite driver to use DirectQuery

[jungkook]

Hi! I was wondering if anyone had any resources for making a custom connector?

More specifically I am trying to make one using Power Query SDK in Visual Studio Code with the M Language, but I am open to any other method.

I am trying to make the SQLite ODBC driver connect to Power BI with the connector and use DirectQuery because I want my data to be able to refresh every 1-5 minutes. I think it is possible because of what this website says but I do not know how to make a custom connector work in that way.

Thank you in advance!

[v-cgao-msft]

Hi @jungkook ,

Check if these samples are helpful.

DataConnectors/samples at master · microsoft/DataConnectors · GitHub

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum