cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
atsats Frequent Visitor
Frequent Visitor

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 imports all rows from an OData entity - which will not work in my use-case due to the large number of rows. In addition, all our queries are global to the data source (so we can't filter to reduce the # of records). So, I have 2 questions:

 

  1. Is there a custom connector that provides Direct Query functionality against OData sources?
  2. If the answer to (1) is no, how does one deal with OData sources that have millions of rows when up-front filtering is not an option (i.e. we always need to run global queries against the source)? 

 

 

 

4 REPLIES 4
v-cherch-msft Super Contributor
Super Contributor

Re: Direct Query for OData?

Hi @atsats 

It seems you may use the custom data connector.For further,please check this similar post.

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
atsats Frequent Visitor
Frequent Visitor

Re: Direct Query for OData?

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/

 

 

v-cherch-msft Super Contributor
Super Contributor

Re: Direct Query for OData?

Hi @atsats 

For your requirement, you may submit an idea here.

Regards,

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
atsats Frequent Visitor
Frequent Visitor

Re: Direct Query for OData?

This idea was already submited almost 3 years ago and Microsoft has done nothing about it:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/13873722-direct-query-option-for-...

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 256 members 2,825 guests
Please welcome our newest community members: