nested subform

[Donia2605]

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

[Anonymous]

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