Forum Discussion
Data not loading into BI from Data Source
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