Record Count Not Matching

[Bhimashankar_Dc]

Hi,

I am using dax query to import data model into power BI Desktop by entering the server name and database name correctly. The Dax query is generated by performance analyzer in Power BI Desktop latest version attached the screenshot.

When I check the data using table visual after importing using DAX I obeserved that record counts are not matching when imported for large data set. The record counts are matching for less than 300 records but not matched for greater than 500 records. 

Will there be any possible data loss occurs if we pull the data using DAX Query for larger data set ?

Note: Data is pulled using DAX for the purpose of plotting the bar chart for a column, which is addressed in Create Visual on frontend measures  this thread.

Thanks,

Bhimashankar

[v-junyant-msft]

Hi @Bhimashankar_Dc ,

May I ask if lbendlin's reply was helpful? If so could you please mark lbendlin's reply as solution so more users can find the answer quickly. Thanks!

Best Regards,
Dino Tao

[lbendlin]

Without showing the DAX query it will be difficult to help.

[Bhimashankar_Dc]

But generally does it cause any data loss when we pull the data using DAX query ?

[lbendlin]

Generally yes.