Forum Discussion
Data not loading into BI from Data Source
I have a BI Report that is used to report out a few of our metrics. Within the last 2 months some of the data is not loading into the report.
All of the data is present in the source file, but when I refresh the BI Report some of the data is not present in the data table or the report.
Hi Anonymous , double check your steps in power query to see if there's no step that is filtering your data.
To troubleshoot, you can re-import the table in the same source and see if there's whole data presented.
3 Replies
Hi Anonymous , double check your steps in power query to see if there's no step that is filtering your data.
To troubleshoot, you can re-import the table in the same source and see if there's whole data presented.Hello Anonymous ,
There can be many reasons, Here are some steps you can take :
1. Check the Data Refresh Process :
=>Ensure the refresh process completes successfully without errors.
=> Check logs or error messages during the refresh
=> Confirm that the missing data is within the date range or scope included in the data source query or filters.
=> Re-run the source query outside of the BI tool (e.g., in SQL Server Management Studio or Snowflake) to confirm it retrieves all expected data.
2. Inspect Filters in the Report :
=> Check if report-level or page-level filters are excluding some data.
=> Ensure slicers in your report do not filter out the missing data unintentionally.
3. Check Data Transformations
Look at data transformations applied in Power Query or your ETL process. Missing steps or conditions in
these transformations could exclude the data.
4. Examine Relationships and Joins
etc
Did I answer your query ? Mark this as solution if this helps. Kudos are appreciated.
Cheers
Hi Anonymous , When refreshing the file do you see any tables with errors ? Like below. If yes, It might be due to data type mismatch. Check the query where you are facing this issue
