Excel to API without going through Power Query

Johnnie Math 0 Reputation points
2023-01-27T22:09:01.7033333+00:00

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!

Excel
Excel
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
1,532 questions
Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,575 questions
{count} votes