Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

AdoDotNet.DataSource and Google PROTOBUF

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?

2 REPLIES 2
v-jingzhang
Community Support
Community Support

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

lbendlin
Super User
Super User

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors