I've created an IUpdateable ODATA feed using WCF which I can connect to using Excel 2010 Power Query. Excel is able to retrieve data but I cannot find a 'publish' button or anyway to tell Excel to push updates back to the server.
Does Excel / Power Query support ODATA CRUD functions out of the box?
Is there another tool I could use to update data without writting code?
1 Answers
Answers 1
Power Query supports reading from data sources, but our goal today is not Create/Update/Delete.
I agree with you--it would be awesome to publish data from Excel without having to write any code!
If you think this is something Power Query should have, I'd go to https://ideas.powerbi.com and vote up the feature (you might be the first with the idea).
0 comments:
Post a Comment