Applies to Product - Microsoft Dataverse
What’s happening?
The report is not displaying data for filters beyond 7 days and is not returning more than 900 records.
Reason:
This is likely related to the query generated by the Power BI product, which is structured based on the applied filters. It returns a maximum of 900 results due to the streaming nature of the Tabular Data Stream (TDS), which leads to timeouts. The dataset may have grown over time, and the way the database is queried is no longer optimal for the size of the dataset.
Resolution:
- Simplify the query to reduce complexity, which may help in retrieving the expected number of records.
- Consider optimizing the query on the user's end to retrieve the desired dataset within the limitations of the platform.
- Each filter added or used in Power BI modifies the query sent to Dataverse, so removing unnecessary filters or reducing data ingestion may be necessary.
- If the issue persists, break the large report into smaller reports based on various criteria.