Share via

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,955 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,978 questions

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.