Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
Hi @Anonymous
You may refer to below post and check if it is helpful.
Regards,
Cherie
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
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.
Hi guys,
Sorry for late response , I got a solution for this issue.
@Anonymous ,@v-cherch-msft Thank You for your response.
Regards,
Vivek.
Hi @Anonymous
It seems you may try to check if there are any filters in Query Editor.
Regards,
Cherie
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |