Forum Discussion
Power BI Desktop doesn't load all the data from dataflow
Ensure that the dataflow itself is refreshing correctly in the Power BI service. If the dataflow doesn't refresh properly, the data won't be available for Power BI Desktop to load. Verify that you have the necessary permissions to access the dataflow.
Dataflows often rely on query folding to optimize data retrieval. If a specific transformation or operation isn't supported for query folding, it might lead to incomplete data loading.Check if there are any filters applied within the dataflow. Filters can limit the data that's available for import into Power BI Desktop. Be aware that there is a size limit for dataflows in Power BI. If your dataflow is too large, it may not fully load into Power BI Desktop due to memory constraints. You can try to reduce the size of your dataflow by filtering or aggregating the data. Check for any connection errors or warnings in Power BI Desktop when you attempt to load data from the dataflow. In Power BI Desktop, when loading data from a dataflow, there are advanced options available. Make sure you review these options to see if any settings are affecting data retrieval, such as filters.