Forum Discussion

sashaxp's avatar
sashaxp
Advocate I
3 years ago
Solved

Power BI Desktop doesn't load all the data from Dataflow

Started to realize that not all data exist in some of my reports and after investigation It turns out that while data exist in dataflow (checked by filtering out data that missing in reports), it doe...
Need Help
  • sashaxp's avatar
    sashaxp
    3 years ago

    So it turns out that clearing up datasource credentials and then authenticating again fixed an issue however we do not understand why it is happened, and also why there is no errors comes up. Trying to identify root cause with msft support. 

vaibhavkale570's avatar
vaibhavkale570
Resolver III
3 years ago

I understand your frustration. Silent data issues in Power BI can be challenging to identify and resolve. There could be several reasons why the data is not loading into Power BI Desktop after refreshing the corresponding table. Here are some potential causes and troubleshooting steps:

  1. Data Source Configuration: Double-check the data source configuration in Power BI Desktop to ensure it is pointing to the correct location and credentials are up-to-date.

  2. Query Editor Steps: Verify the applied transformations in the Query Editor to ensure that data filtering or manipulation is not inadvertently excluding the missing data.

  3. Refresh Errors: Although you mentioned there were no errors, it's still worth checking the refresh history and logs to see if there were any issues or warnings during the refresh process.

  4. Data Model Relationships: Make sure the relationships between tables are correctly defined. If there are issues with the relationships, data might not appear as expected.

  5. Data Load Settings: Check the data load settings in Power BI Desktop to see if there are any filters or restrictions that might be causing the data not to load.

  6. Column Data Types: Ensure that the data types of the columns in your data source match the data types in the Power BI data model. Mismatched data types can cause data not to load correctly.

  7. Partitioning: If you're using data partitioning in your dataflow, check if the partitions are set up correctly and if the missing data falls within the specified partition range.

  8. Dataflow Refresh: Verify if the dataflow itself is refreshing successfully. It's possible that the data is present in the dataflow, but the dataflow itself is not updating.

  9. Cache and Query Folding: Power BI might be using cached data or applying query folding, which could lead to incomplete data. Try clearing the cache and disabling query folding to see if that resolves the issue.

  10. Power Query Formula Errors: Review the Power Query formulas in your dataflow to ensure there are no errors or issues that might be causing the data not to load properly.

  11. Date and Timezone Considerations: Check if there are any date or timezone-related issues that might be affecting the data filtering or loading process.

  12. Power BI Version: Ensure that you are using the latest version of Power BI Desktop to take advantage of any bug fixes or improvements.