Error The Table object with name 'Table' does not exist.

[Susil540224]

I'm currently doing a directquery on a dataverse and was using powerquery to create a new date table. 
The formula is as follows: 
dimDate = ADDCOLUMNS(
CALENDARAUTO(),
"MonthID", MONTH([Date]),
"Month", FORMAT([Date], "MMM"),
"DayNumber", DAY([Date]),
"DayName", FORMAT([Date], "dddd"),
"DayID", WEEKDAY([Date], 2),
"Year", YEAR([Date]),
"Today", TODAY(),
// Add a SchoolYear column that adjusts the year based on the month
"SchoolYear", IF(
MONTH([Date]) >= 9,
YEAR([Date])+1,
YEAR([Date])
),
"SchoolMonthID", if (MONTH([Date]) >= 9,
Month([Date])-9,
Month([Date])+3
),
"Report Refresh",Now() //We'll use this to display the report refresh date
)

When going onto the visualisation pane, I want to create a hierarchy on the Schoolyear column. I keep getting the error The Table object with name 'Table' does not exist. 

I tried looking online bu i am not able to get any help on the issue.

[Abhay3311]

Solution:

https://abhayagastya77.blogspot.com/2024/11/table-object-with-name-table-does-not.html

[Abhay3311]

Check this video to resolve your issue. 

https://abhayagastya77.blogspot.com/2024/11/table-object-with-name-table-does-not.html

[Anonymous]

reopen resolve my issue.

[scottko]

Just happened to me trying to create a hiearchy on new calculated table.

[scottko]

Closing and reopening power BI fixed it for me.

[Har_yd]

Yeah, I had the same problem and this worked for me too, Thanks @scottko 

[Susil540224 · Accepted solution]

Hi Guys, Thanks for the support and help. 

I am unsure how, but the error went away after a day when I reopened the file without changing the power query.

[GiuseppeMR]

Hi,

Today I have found the same error reported by @Susil540224 .

In particular, in my PBIX file, I received the error when I tried to create a measure on a calculated table.

The weird facts:

- If I rename the calculated table to "Table", I am able to define the measure without errors.
- If I create a new PBIX file with a simple calculated table (e.g. calendar(from, to)), I am not able to define measures on this table (due to the above error).

Could the error be related to the latest Power BI version released in July?

[Sherihan_Ali]

I have the same Problem 

[Anonymous]

Hi @Susil540224 ,

Can you provide the pbix without sensitive data for us , thank you!

Best Regards,

Xianda Tang

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

[facupola]

Hi, I have the same error: "The Table object with name 'Table' does not exist"

I can solve it by saving, closing the file, and reopening it.

However, there seems to be an error in the latest Power BI version released, Version: 2.131.901.0 64-bit (July 2024).

To reproduce the error:

1. Create a new table by selecting "Enter Data".

2- Click the Load button without adding any columns.

3- Rename the table.

4- Add a new measure. (The error appears)

Error Message:
The Table object with name 'Table' does not exist.

Stack Trace:
Microsoft.PowerBI.Modeler.ModelingASOperationException
at Microsoft.PowerBI.Modeler.TomExtensions.ThrowAsModelingASOperationException(Exception ex)
at Microsoft.PowerBI.Modeler.TomExtensions.ExecuteTomOperation(Action action)
at Microsoft.PowerBI.Modeler.ModelManager.InternalTransaction.<>c__DisplayClass14_0.<SaveChanges>b__0()
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.<>c__DisplayClass9_0`1.<RunInActivity>b__0()
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity(ModelingActivityKind activity, Action action)
at Microsoft.PowerBI.Client.Windows.Modeling.Hosting.ModelingTelemetryService.RunInActivity[T](ModelingActivityKind activity, Func`1 action)

Here is the PBIX file, but I'm not sure if it will help because after closing it, it works fine. However, if you follow the steps, I get the error again.

test-File.pbix 

Hope it helps.

Thanks,

Facundo Capdevila