Difference between API V1 and V2

[klincecum (Kevin Lincecum)]

@aosemwengie1

How?

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. …

@Mark_Wonsil

On the OData feed or another?

I think all of it, but I’ve slept since then.