The drill-through capability is not enabled in the new Add-in. This is very important, especially in the controlling department, where you want to see what's behind aggregated values (E.g., specific invoices and related details)
Lists are also not possible to use in the Add-in, usually, I create a list where I have a delta to show the difference between the other two columns. A common use case would be to have a pre-made report where you have Plan vs Forecast and then hav...
Enable copying connections details from cloud console to 365 add-in
If you copy your connection details from the cloud console, you could paste them into the Excel Add-in. This isn't possible anymore - and I think never worked - in the new Add-in for Excel 365. Please implement this for the new add-in, because oth...