Forum Discussion
Direct Query for OData?
I have an OData endpoint with over 8 million rows. I would like use something analgous to Direct Query against OData sources (like Direct Query for database tables). It seems that Power BI always imp...
Hi atsats
It seems you may use the custom data connector.For further,please check this similar post.
Regards,
Thanks, but based on information I reviewed, I think creating a direct query custom data connector for OData is a substantial project. It also seems that only ODBC custom connectors can support direct query, which means that the custom connector has to be an ODBC type.
There's a company already offering this ODBC->OData connector for Power BI, but it's pricey for large-scale deployments: https://www.cdata.com/drivers/odata/order/odbc/
This idea was already submited almost 3 years ago and Microsoft has done nothing about it: