Sage 200 Standard and Power Bi $expand=tax_analysis_items

[Carrie Ellwood]

I am trying to understand how I can see the tax analysis items in power Bi, I have followed the instructions to this point:

= #"API Query"("Purchase_Transaction_Enquiry_Views",null,"$expand=tax_analysis_items")

and it loads without error, but I need to understand the next steps so I can see the tax analysis details like id, code, name, entry_type, goods_amount, tax_amount, tax_discount_amount

I also need to do this for the = #"API Query"("Sales_Transaction_Enquiry_Views",null,"$expand=tax_analysis_items") and for = #"API Query"("Nomunal_Transaction_Enquiry_Views",null,"$expand=tax_analysis_items") 

Many thanks in advance