Tim on 08 Feb 2016 18:36:29
With power query you can perform Create update and delete operaiton with an OData feed? If not this would be an awesome feature to have.
- Comments (4)
RE: Q&A Can you perform CRUD operations with PowerQuery OData?
Upload would be awesome.
Many bespoke processes in SAP are build around downloading data from SAP into CSV, amending it there and then loading it back manually into SAP. With OData upload from Excel/PowerBI this could all get integrated into one Excel/PowerBI file. OData is build into SAP.
RE: Q&A Can you perform CRUD operations with PowerQuery OData?
This would be useful to have for managing data through APIs instead of giving users direct access to a database for managing data. There are still companies not using things like Sharepoint Online to be able to manage lists of data. This would be a super useful feature.
RE: Q&A Can you perform CRUD operations with PowerQuery OData?
I agree. We spend a lot of time in our organization dealing with users who'd rather use excel than a website to manipulate data. Sometimes it's difficult to get them to use web forms at all and we end up getting calls asking us to import data from their spreadsheets. Having a solution for users of this type would be a great asset.
RE: Q&A Can you perform CRUD operations with PowerQuery OData?
This is not currently supported, but would be nice to see.