We have a new Service Account made for us. But when I log in to connect to the PowerBI OData Feed using my own Super Admin account, then I am able to retrieve all the Company Divisions data. However, when I try to access it via the Service Account, then I only get one Company Division back.
I use the ExactOnlineREST.FinancialTransaction.TransactionLinesBulk table. So the data retrieved from that only consists records from one Company Division.
I have tried using another Super Admin user account to access the database as well. And that is able to retrieve all the Company Divisions data. Only the Service Account is not able to.
My Exact Online Account has admin rights. So think something is happening with the Invantive Cloud side.
OK, happy that the two Invantive Cloud users see the same data when using the Invantive Cloud SQL Editor.
Perhaps the differences are visible only when using Invantive Bridge Online? Bridge Online adds various caching mechanisms, whose lifetime is per user and per database. Please see Differentiate OData4 for Power BI Cache Behavior for more information.
The start of the cache’s lifetime is per user different.
Please check the cache intervals set in case the problem only occurs when querying using Invantive Bridge Online and remember that an identical data download by two different users can have different cache lifetimes start values.
In Invantive Bridge Online Monitoring you can see displayed as a checkbox for each different user whether the data was taken from cache or not. The Bridge Online Monitoring solely displays data currently from the connected Cloud user so you may have to switch between browser sessions.