The existing APIs connecting Power BI to BC are entirely inadequate. I have yet to meet a customer who doesn’t need fields added to multiple APIs just to create simple reports. This adds unnecessary time and expense to report development as consultants have to involve developers.
Other reporting tools such as Cosmos and Jet Reports allow read only access to every field in every table in BC.
Rather than multiple limited APIs, we need a connector that allows report developers this kind of access to the data.
Comments
Matthew, I feel your pain! I am new to creating reports using BC data and the need to either have custom APIs created or have multiple APIs connected is maddening.
Category: Reports and Business Intelligence