Forum Discussion
Failed to Display Data
- Anonymous1 year ago
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 existsEVALUATE 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.
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.