Failed to Display Data

[Sobha]

Hi, My report is a Paginated report It has a table with Row groups and Column groups. Both groups are based on Year/Month. There is starting year/month and ending year/month. report calculate the sum of amount for year/month for column groups and row Groups The issue: If the year/month is like 1/1/2024 to 12/31/2024 it displays Data. But if it exceeds that time period, it came back with no data. Like start is 1/1/2024 and end is 3/31/2025. In DB Side it is fetching the data. But in Power BI Side it is failing to display data. Is there any Log is available to check the Power BI Errors. Thanks.

[Anonymous · Accepted solution]

Hi, @Sobha 

Check the time filtering logic of the paginated report to verify the date field format to ensure that the date fields for the row and column groups are full date types (such as Date type) and not a year/month combination in text format. Adjust the time filter parameters to ensure that the start and end parameters accept cross-year values (e.g., the parameter type is Date, not hard-coded year).
Check the dataset refresh configuration in the Power BI service to view the refresh history. Sign in to the Power BI service → workspace where the dataset is located→ select the dataset → click Schedule refresh.
Check the recent refresh record for errors (e.g., timeouts, credential errors). Refer to the list of data sources that do not support refresh to check whether your data sources are supported. If the dataset is large, optimize the query in Power Query, or contact your administrator to increase the gateway timeout threshold.

Troubleshooting unsupported data source for refresh - Power BI | Microsoft Learn

Troubleshoot gateway issues, such as using on-premises data sources, open the On-premises Data Gateways app on your on-premises server → confirm that the status is Running. You can check the event logs, Event Viewer→ Application and Service Logs, → On-premises Data Gateways services for error events. Or reconfigure the data source credentials. You can also contact your Power BI administrator to export server-side logs or view related diagnostics through the Azure portal.
You need to make sure that the fact table and the date table are correctly associated with the date field. Using the DAX debug time frame, run the following DAX in Power BI Desktop to verify that the data exists:
Example: Check if 2025 data exists

EVALUATE
FILTER ( 'FactTable', YEAR ( 'FactTable'[Date] ) = 2025 )

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.