Reports written in Excel

[gpayne (Greg Payne)]

This thread has a bunch of ways to do that.

Pulling BAQ into Excel - Web API, OData, JSON?

I have created an API and set its scope to just the BAQ I want to return. In the REST helper, I can paste the API in the header for REST v2. I get the data back as expected in the REST helper. However, I want to use this data in Excel to make some charts. I have tried a few different ways to pull it in, including power query editor, and the =webservice formula. Nothing has worked so far. I couldn’t get the power query editor to return anything, and the webservice formula always returned #Value. …