I have a dataflow on a workspace premium capacity.
I have a pbix file and I take all the data from the dataflow.
I added a new table in the dataflow, everything perfect, all the data is in it after all the calculations.
But when I tried to load this table in Power BI desktop, just 20% of the rows are loaded.
I tried from another blank pbix file and it happen the same thing. Exactly the same data are loaded in it but it represent about 20% of the whole table.
I don't do any calculations on it (in PBI Desktop) and it is just like that.
I don't really have more info to give you... I investigated and didn't find anything...
Did this already happen to someone?
Thank you in advance
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.
I have this exact same issue. My dataflow has ~15M rows but Power Bi desktop is only retrieving ~4M rows. Power BI Desktop only connects to the dataflow for this table without any filtering.
@amitchandak thank you for your answer.
There is the right amount of data into the dataflow, the refresh is ok.
And I checked Power Query ther is no error in loading, and as I said, it happens exactly the same in other reports when I'm loading the same table. The same rows are not loaded...
This is really unbelievable, everything looks like everything is ok! But there is just not all the data in the table... I really don't understand how it's possible
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.