You'll need to use the '$expand' query parameter. 

../sales_transaction_enquiry_views?$expand=nominal_analysis_items

Hi,

thanks. i have = #"API Query"("sales_transaction_enquiry_views", null, "$expand=nominal_analysis_items") but still doesn't return the data

Hi Gareth,

If you haven’t already, can you confirm if the same request, using ‘$expand’ as Chris suggested works outside of PowerBI? Have you tried the same request via a separate client such as Postman? 

Unfortunately we don’t support the specifics of using PowerBI to make queries, but we would support you in ensuring your API is set up correctly and data is returned successfully. 

Regards,

Ben

Hi,

our Sage 200 is provided by a 3rd party using Azure Remote desktop. We can only access the sage API data through this environment (i have power BI app on my azure desktop) i don't have access to anything else (edge etc) so don't believe i can run through postman??

thanks

Gareth

Hi Gareth, Can you advise exactly what happens when you attempt this through PowerBI? Do you get an error returned?

Ben

Hi,

no error is returned, just no extra fields

thanks

Gareth

Gareth Parry  Did you ever resolve this as I am having the same issue now?

no. still waiting on sage support