missing rows in power Bi from Power Query

[Anonymous]

Hi everyone, 

I have a problem with a table in my powerQuery importing data to Power BI

So I have this table 'History' in my power query, and you can see that there is a value 'PIL-137578' in the column key.
But when I'm looking at this table in power BI desktop, I can't get this key and I have the same problem on a lot of other rows.
Obviously i cleaned all my filters, I did 2 refresh but nothing change. 
Does anyone has an idea of what is going on ? 

Thank you for your time.

[Syndicate_Admin]

Thank you. Worked

[v-stephen-msft]

Hi @Anonymous ,

Just to double-check, did you refresh the data in Power BI Desktop or in Power Query Editor? Just want to check if the data you're looking for is still in the data source itself.

Refresh in Desktop:

If it's there, but not in the table view, be sure to right-click on the top of the column and clear all filters. Sometims we may forgot about the old filter from a few hours ago.

If it still doesn't appear, try filtering only for missing data in Query Editor and see if it appears in the visual. 

Best Regards,

Stephen Tao

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

[adudani]

HI @Anonymous ,

are there any errors in the query on refresh?

if not,

try filtering the columns in PQ on some examples of the ID's. Do these load when specifically filtered?

Let me know.