google analytics ecommerce data

I'm pulling down data from our Google Analytics account, but being a Google Analytics Premium customer with a fully enabled datalayer, we are sending rich ecommerce data into our google analytics account. This ecommerce data doesn't seem to be accessible even though I know I can download through their API directly all this data - I've done it with other visual BI platforms like Tableau and manual dumps into bigquery. I'm wondering if I've missed somthing when I enabled my account?

You can go here and look at all the dims and metrics available (including custom) - https://developers.google.com/analytics/devguides/reporting/core/dimsmets and here https://ga-dev-tools.appspot.com/query-explorer/ as the current PowerBI build seems to only include about 10-20% of what is available.

Please help me access all of our rich data in GAP. Thanks! 🙂