Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
Hi @Anonymous
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
If you're just starting with this I would recommend to use the JSON output instead. Easy to ingest in Power Query.