SAP BO Analysis Automation

Intro SAP BO Analysis for Office is an Excel add-in from SAP. And like any good Excel add-in, it has API, which allows to use VBA macros to execute certain methods of add-in. Main purpose of this add-in is to…

Query SAP Business ByDesign Web Services via Power Query

In this post I would like to share my experience about work with web services using Power Query. Unfortunately, some very important information is not available in data sources, e.g. Accounts Relationships and Pricing Conditions (price lists, customer specific discount lists…