Forum Discussion

Gabry's avatar
Gabry
Icon for Super User rankSuper User
1 year ago

Help needed, including '$' prefix in OData v2 parameters with Power Query

Hello everyone, I'm trying to connect to a SAP OData v2 service using Power Query in Power BI. I'm accessing an endpoint that requires query parameters with the '$' prefix, as mandated by OData v2....
Need Help
  • Gabry's avatar
    Gabry
    Icon for Super User rankSuper User
    1 year ago

    Hello PhilipTreacy ,

    thanks for the suggestion. I tried but then when published to the service can't be refreshed because of dynamic data source error.
    Code was like this:

        baseURL = "http:......",
    
    
    queryParameters = [
        #"$filter" = "C....",
        #"$expand" = "to_M.....",
        #"$select" ="M......e",
        #"$top" = "10"
    ],
    
    queryString = Uri.BuildQueryString(queryParameters),
    
    fullURL = baseURL & "?" & queryString,
    
    Source = OData.Feed(fullURL, null),