The model doesn't have a table named X

[emzbr]

I made the mistake of changing a table name in query edit mode from Activities to _Activities and now, when I try to refresh, I get the following error "The model doesn't have a table named Activities". I then tried to go back to the original name, yet I still get the error, this time "The model doesn't have a table named _Activities".

How do I get unstuck..?

Thank you!

Emma

[Rex-Eight-It]

The solution is fixing the Applied Steps.  If you merged or appended two queries:

1. Remove your appended/merged step (basically reset your steps to before you encounted the problem).
2. Go to the step right before you want to apply a merge/append.
3. Highlight that step.
4. On Home tab, select Combine, then choose your combine type.
5. Follow the prompts to apply the merge/append, selecting the table you want to action.
6. If you applied more than one merge/append, you'll mostly likely need to repeat for each applied step that was that action.
7. Step thru to the end to ensure you don't get an error anymore.
8. You can now Close & Apply.

The error occurred because the table was renamed "out of order" of the append/merge.  Even though renaming a table isn't an Applied Step, the steps still reference the table names, so they do have to be named according to what the steps expect.  Just remember to "rename" after you append/merge.  This most often occurs when the merge/append step is created and then a table is rename earlier in the steps.  Note, this can also happen if columns are renamed; however, you do see applied steps for that scenario so it is easier to spot.

[Polochkinov]

I recommend deleting the query/table that creates the issue (but copy the advanced editor section) and recreate it after. It solved it for me.

You might have to recreate the relationship afterward.

[Joris_NL]

I had a similar problem and found the solution.

After some random software update in the database, I had to rename all my tables from ALL-CAPS to Normal-Caps. So following your example, I changed 'ACTIVITIES' to 'Activities' - and renamed all corresponding query steps, column names etc. When trying to apply the query changes, I got the following error:

The model doesn't have a table named Activities 2.

Even though the query didn't mention 'Activities 2', and never had done. I double checked this by copying the query to Word (or NotePad) and searched ctrl+f. No 'Activities 2' ever existed in my entire file. Why it asked for number 2, I never found out, but I did find a solution.

First I added a new table, called 'Activities 2'. This resulted in the error message saying:

The model doesn't have a table named Activities 2 2.

So that wasn't going to work. The solution, however, was to change the name of the original 'Activities' table to 'Activities 2'.

This solved the issue and everything worked again - although I had to repeat this step for all other tables. Funnily enough, after applying the query changes I could change the name 'Activities 2' back to 'Activities' as if nothing ever happened.

Most software doesn't allow for multiple files with the same name, irrespective of caps. So when changing ACTIVITIES to Activities, it might make a copy (number 2) behind the screens. Thogether with a database update, this might mess things up. But it's only a guess. 

Hope this helps for future troubleshooting!

Joris

 

[Anonymous]

I tried the solution (the names are identical, I still tried to copy/paste from one to another), but it didn't work. I also watched the recommended video, but this was for a measure, not a table, not found. I can't find any other solutions anywhere. Can anyone help? Thanks.

The message I get is the same: 

"The model doesn't have a table named <name of table>"

[Pascal_KTeam]

Actually the video is also for a table and not a measure.  It's for a measure table though...

Is your table also a measure table?

[Anonymous]

No, it is not. 

[Pascal_KTeam]

OK, then the issue might be a different one than in the video. I haven't had this issue in years and don't have a file that has the same issue so unfortunately, I can't help with it. 

[Anonymous]

In case anyone runs into this issue, I had to recreate the entire pbix (what a pain). I wasn't able to get rid of the error. So word of caution, if you make changes to your appended or merged table, applying the changes may not recognize your tables anymore. 😞

[Pascal_KTeam]

Normally this error is related to the issue explained in this video

https://youtu.be/jp0-ryvw9EM

[Anonymous]

thanks for the help!

[v-chuncz-msft · Accepted solution]

@emzbr ,

Try to rename the table in The Fields pane.

[Anonymous]

THIS IS NOT A SOLUTION NOT SURE HOW THIS WAS ACCPETED AS A SOLUTION