AdoDotNet.DataSource and Google PROTOBUF

[alanwthomas]

I'm building a Custom Data Connector to a web service's REST API that returns results in any of a choice of formats: CSV,XML,JSON, or PROTOBUF, which I understand to be the most efficient/fastest. I'm able to obtain the Protocol Buffer result from the server but I don't know what to do with it afterwards. I've come across https://github.com/protobuf-net/protobuf-net and https://github.com/dotarj/protobuf-net-data, and I suspect it might be possible to leverage these via AdoDotNet.DataSource if I install them, but I have no idea what the function's arguments should be. Any suggestions on how to proceed?

[v-jingzhang]

Hi @alanwthomas 

It may be difficult to parse data from PROTOBUF format. I don't find function about this format in Accessing data functions - PowerQuery M | Microsoft Docs. I think it may be not supported unless you can convert it into a format Power Query M can deal with. 

Best Regards,
Community Support Team _ Jing

[lbendlin]

If you're just starting with this I would recommend to use the JSON output instead.  Easy to ingest in Power Query.