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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Odata connection with filter in Gateway

I'm setting up some new Odata connections in the gateway.  The first was created successfully, but the second gives an error.  Upon investigation, some Odata connections that were working are now giving errors.  The connection that I could not create included a filter (...?$filter=Order eq 'O'); if I remove the filter, the connection is successful.  However, this connection requires the filter in order to return data.

 

The same url with the filter returns data without issue in Power BI Desktop.

 

Here is the error I am receiving when creating the connection:

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."

 

More details on the error:

Underlying error code:-2147467259
Underlying error message:Timeout expired. The timeout period elapsed prior to completion of the operation.
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.HostingError.Reason:Timeout

 

Also of note, when I click the 'Troubleshoot connection problems' link, I get a 404 error.

2 REPLIES 2
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@Anonymous,

Currectly, OData filter are not supported in Power BI Service although it's working in Power BI Desktop.

 

The solution is to Filter from the Power Query editor that generate a call to the function Table.SelectRows: https://msdn.microsoft.com/en-us/library/mt260810.aspx.

 



Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Thank you.  However, the filter was removed and it is still not working.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.