OData Timeout Problem

[dilaraa12]

Hi,

We keep our data in SAP. That's why, we use OData. But our data is multi-row (150,000+ rows, 450,000+ rows). I'm getting a timeout error when connecting these tables to Power BI. I couldn't find a way to bind the data. Do you have any suggestions on this matter?

Or would it be better to connect our data in a way other than OData? There were people who did not recommend using Odata. Is using OData a wrong decision?

It was said that it is better to extract data with ODBC Driver. Does it make more sense to connect teradata with ODBC, at least for big data?

Thank you in advance

[v-rongtiep-msft · Accepted solution]

Hi @dilaraa12 ,

You can  use other methods to connect to your SAP data, such as ODBC or OLE DB. These methods may offer more flexibility and functionality than OData, but they may also have some drawbacks, such as:

They may require additional drivers or software to be installed on your machine or gateway
They may not support query folding or server-side processing, which can affect performance and efficiency
They may not provide metadata discovery or automatic relationship detection, which can require manual configuration or editing

Enabling DirectQuery for an ODBC-based Power Query connector - Power Query | Microsoft Learn

Use the SAP Business Warehouse (BW) Connector in Power BI Desktop - Power BI | Microsoft Learn

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AmiraBedh]

Similar thread : https://community.fabric.microsoft.com/t5/Desktop/OData-Feed-error-time-out/td-p/1678275