Need help in Invoice API to get line_item details

Need help in Invoice API to get line_item details

Dear community, 

Appreciate if you guys could give a little help, have been struggling.. 

I am building a dashboard with Power BI to analyse data from Invoice. 

If I were to export the invoice into an excel file, I can view details such as item name and description. 
However, if I were to directly link the Power BI to Invoice API database, I am unable to retrieve any data of line_items such as item id, item name, description etc. 

May I know if I'm getting the data from the correct source?