Same sql server query gives Different Count of rows in SSMS and PBI

[Anonymous]

Hello guys,

To design a report ,i am using SQL server as backend data source .

but the same query gaves a different count of rows in power bi desktop and in Sql server Management Studio .

For more clarification find below snap of ssms result window and PBI query editor -> count row window.

Same query gives 42666 count in SQL Server while PBI gives only 28529.

Thank You in advance 

Regards,

Vivek Chavan

[v-cherch-msft]

Hi @Anonymous

You may refer to below post and check if it is helpful.

https://community.powerbi.com/t5/Desktop/Rows-missing-in-imported-data-from-SQL-Connection-Power-BI/td-p/279328

Regards,

Cherie

[Anonymous]

Hi @v-cherch-msft 

Thanks for your response , In my case I am using Direct Query mode for extracting the data from SQL Server.

My problem still persists.

Could you please again check on this..!!!

Thanks & Regards,

Vivek Chavan 

[Anonymous]

Hi @Anonymous,

It's very diffcult to Answer your question by seeing screenshot's, please reproduce the issue with some sample data so that anyone can help you in much better way.

[Anonymous · Accepted solution]

Hi guys,

Sorry for late response , I got a solution for this issue.

@Anonymous ,@v-cherch-msft  Thank You for your response.

Regards,

Vivek.

[v-cherch-msft]

Hi @Anonymous

It seems you may try to check if there are any filters in Query Editor.

Regards,

Cherie