Forum Discussion
Error The Table object with name 'Table' does not exist.
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.
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.
11 Replies
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?
I have the same Problem
Just happened to me trying to create a hiearchy on new calculated table.
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.
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:
- 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.
Hope it helps.
Thanks,
Facundo Capdevila
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.Check this video to resolve your issue.
https://abhayagastya77.blogspot.com/2024/11/table-object-with-name-table-does-not.html
