Can JdbcOdata be used as an ODATA source from MS PowerBI?

[pbeltranl]

Hi,

It works against a custom relational database which is awesome.

I am now able to query tables and see records, count, metadata... from the browser.

How could this be used as a data source from MS PowerBI or other industry reporting & analytic tools?

Any guidance would be very much appreciated!

Pablo.

[Bartman0]

did you try?: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-connect-odata

It should work, unless Power BI uses some specific stuff that this library can't handle.
I am using the library to support external data source querying from Salesforce successfully. With Snowflake as an underlying database, but you could use any JDBC capable database of course.

See: https://github.com/Bartman0/snowflake-odata

One important remark: I refactored it to work at the schema level, and not at the individual table level.
But you could cherry pick stuff from there to get a working service in a Docker container. That's how I deploy it.

[wernerdaehn]

FYI: I have added a second kind of endpoint to expose all tables of a schema at once.

[wernerdaehn]

@pbeltranl Did you make any progress in testing it?