Regarding drawbacks or weak points in Microsoft Power BI, it may not be directly related to the tool itself, but with our architecture, as we couldn't get a service account, which is an email address that has no relationship with the employees, just to establish the connection with Anaplan. We couldn't get it to work on SSO, so we use an employee account which could be a point of weakness, meaning if the person leaves, that connection will break. If the person goes on holiday and we need to refresh, we have to change the connection as well, but we have to live with that since we're not using SSO on the service account. Regarding the natural language processing feature, we're trying to avoid using it too much because it can slow down the connection, so as much as possible, we try to build the logic and any transformation in Anaplan, and then deliver an end product to Microsoft Power BI.
