Something is off with data table to Power Query

[Anonymous]

Hi Power BI Community,

I have this data in the data table: 

But in the Power Query this data: 

 
Is this a problem of relationship? But even without any relationship it does not show the same data. I also refresh the data several times..

[Anonymous]

Hi @Anonymous ,

Please check the following threads which have the similar problem with yours, hope their solution can help you resolve the problem.

Data Not Showing Up

Data not Showing up

Best Regards

[negi007]

@Anonymous you can change the dispaly format of the date in powerbi desktop like below

[Anonymous]

@negi007 Thankx I already know. This is not the issue. I have data in Power Query (Jan, Feb 2021) which is not shown in the Power BI Desktop

[amitchandak]

@Anonymous , power query only shows sample 1000 records. So it might few rows from your data.

Are you missing any data?

[Anonymous]

@amitchandak Thankx for the reply but this is not the issue. 

Why is more data in Power Query - second pic (Jan, Feb 21) then in my Power BI desktop data view - first pick