Forum Discussion

Donia2605's avatar
Donia2605
New Member
2 years ago

nested subform

Hi,

I am trying to retrieve OData from a table, a subform, and another nested subform using the following URL:

 

https://XXX/odata/XXX/ORDERS?$filter=CURDATE ge 2024-07-15T00:00:00Z&$expand=ORDERITEMS_SUBFORM($expand=ZUCC_SUBFORM)

 

It is working from the API but not in Power BI Desktop. its shown this error:

 

 DataFormat.Error: The odata.context url 'https://XXX/odata/XXX/ORDERS?$filter=CURDATE ge 2024-07-15T00:00:00Z&$expand=ORDERITEMS_SUBFORM($expand=ZUCC_SUBFORM)' is invalid


General Comment
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Donia2605 ,

    Regarding your issue, it seems that there is no problem with the URL, it just doesn't work in Power BI. You can try clearing the cache of Power BI Desktop and User Permissions. Or rolling back the 'Odata' version,I saw some articles mentioning that higher versions of odata cannot be used properly in Power BI Desktop.

     

    Best Regards,
    Wenbin Zhou