recently added new sheet is not updating the total count in Power BI

[Abhishek8895]

I have a data model that currently had 5 sheets from excel (Sheet 1, 2, 3, 4 & 5}. However now data has become bigger and now we have another sheet 6. I have added it through advance editor and even the load is enabled but still the overall count is not increasing..Would anyone know why?

[Anonymous · Accepted solution]

Hi @Abhishek8895 ,

In power query-> "remove rows" section, click remove errors and check if error disappeared.

In addtion, it seems this issue should be related to data format can't be recognized by power query,I would suggest you to refer to this thread:

Solved: error message after building query returns zero ro... - Microsoft Power BI Community

In general this happens when there are no errors in the query, but errors occur when the query results are loaded into the data model.

Examples:

• unique key values in Power Query (case sensitive), that are not unique when loading (case insensitive), 
• numbers with fractions in a column with data type Int64.Type (Whole Number),
• etcetera.

Specializing in Power Query Formula Language (M)

x of the loaded queries contained errors - but viewing errors shows none? (microsoft.com)

• This phenomenon typically happens when your columns contain data that doesn't match the data type of the column. This is allowed in Power Query, but not when the data is loaded.
• Solving the errors: make sure the data types of the columns match the data types of the values in the columns. 

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Abhishek8895]

[Abhishek8895]

thanks, but as already stated, it not enable load because all that I already tested and from the screenshot its clear that the load is happening but the numbers are not getting sum total, should be 16.5K but stuck at 15.9K

[Anonymous]

Hi @Abhishek8895 ,

Can you refresh the data in the Power Query? If you have cancelled Enable Load? Please check first, and then refresh the data in the Power Query.

I have also found a similar post, please refer to it to see if it helps you.

Power Query does not refresh (microsoft.com)

If it still does not help, please provide your pbix file without privacy information for us testing.

Best Regards
Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.