Forum Discussion

RodneydeBeer's avatar
RodneydeBeer
Frequent Visitor
2 years ago

OData feed with Parameter Aliases not Working

Hello. I am following this blog that has been refered to in other threads on this forum. Using OData.Feed and the Query option to avoid the dynamic data sources error in Power BI (crossjoin.co.uk) ...
Need Help
nedpbi's avatar
nedpbi
Icon for Helper I rankHelper I
1 year ago

RodneydeBeer were you able to fix this ? 

 

I am trying to do something similar but I get the same error. The error goes away if instead of $filter in the url, i use filter without the $ sign. I think the parameters are passed but I don't see the data being filtered.

 

Thanks !

RodneydeBeer's avatar
RodneydeBeer
Frequent Visitor
1 year ago

Hi.

I could not. Was extremely frustrating for such a basic requirement. Not being able to build a dynamic querystring is, in my view, a major flaw in the product.

 

Eventually I hardcoded the querystring and we put a standard operating procedure in place for the support guys to MANUALLY change the hardcoding every month. Terrible, but it is what it is.

 

Cheers

Rodney

  • nedpbi's avatar
    nedpbi
    Icon for Helper I rankHelper I
    1 year ago

    Thanks RodneydeBeer for getting back !

     

    Yes, frustrating. As I mentioned when i replace $filter with filter in the url, it does not give the error and seems like the parameter alias works and is passed to the backend, but the OData feed does not seem to filter this for some reason. I am not sure if this is because of the configuration on the OData feed or if the filter is not interpreted correctly as its missing the $ sign.

     

    Hopefully they will fix this in the future.

     

    Thanks again !