I m a new user of Acumatica, I would ask the other more experimented users, is there some way to retrieve data from the cloud database down to Excel like I was used to do with my MS SQL Server database, via Power Query fonctions (I had of course the Server address, username and password to be authorized to get in) ?
thank you very much.
Best answer by Gabriel Michaud
You have a few options:
The advantages of Velixo are numerous: ability to drilldown to Acumatica, better performance (data caching and smart refresh, ability to filter results based on cell values), inline functions that let you use data anywhere and not just in a table, support for single sign-on, Mac/Excel Online support, and more… check this video for a full demo or this one for a presentation on Generic Inquiry functions. Disclaimer: I built this product