Dataset API
Can I use the dataset API in the Power BI Online service?​
Yes, you can use the SoftExpert Suite dataset API as a data source in Power BI Online. However, it is important to remember that, for customers that have SoftExpert Suite on-premise environments and are on private networks, access to the Power BI Online service must be ensured for proper functioning. In these cases, we recommend you consult your Infrastructure team responsible for supporting SoftExpert Suite or the Power BI documentation itself.
Is it possible to set up pagination in the dataset API?​
At the moment, the dataset API does not support pagination. This means that only the first 10,000 (ten thousand) records can be obtained as objects. If a customer needs to retrieve more records, they will need to create a logic in their SQL script in order to get the total number of records returned on the dataset view or creation screen.
Not all APIs support pagination. When that happens, it may be necessary to create alternative logics on the customer's side for the manipulation of large datasets, such as splitting the query into smaller pieces or getting the total number of records in order to allow the results to be displayed in stages.