Hello! We recently connected Power BI to our API and Power BI read the data right into a table (just about automatically). We want to do the same thing with an Excel connection to our API. However, every tutorial and video I've seen shows that you must do a couple manipulations in Power Query to get the data into a table. The couple manipulations I am referring to are:
1. Click "Into Table" once Power Query opens after connection to the API.
2. Click "Expand to new rows"
3. Click the same icon to convert and pull in rows
4. Close and load.

Anybody able to pull data into Excel without having to go through these steps?

Thanks!