Not all Tables showing up under Data in the PowerBI Desktop

[krypto77]

Hi Everyone,

New user here and having a basic, yet annoying problem.    In Power Query Editor, I've created 45 queries, that work well with no errors.   When I click on Close & Apply, I am taken back to the Power BI Desktop view, but I have two problems.

1.   In the left panel, under Data, I only see 8 tables out of the 45 I created.   Not all the tables are there based on the queires I created.  Not sure how to get all 45 to appear?

2.   I always get "There are pending changes in your queries that haven't been applied".   Click Apply Changes or Disccard Changes.  I hit Apply, no errors but this message never goes away.  Its always there.

Thanks in advance for any guidance. 

[krypto77]

@amitchandak Thank you, it worked!  Appericate the assitance. 

[amitchandak]

@krypto77 , It means there is some problem with the file now.

Try this, do this one by one for a few tables.  Do some minor changes and apply.

After you do it should appear in DATA view. Without closing keep on doing that.

If needed discard the changes first and then do this. Keep a backup of file