Forum Discussion
Table Name Duplicate Error
Hi rmit0422, auto date/time creates hidden LocalDateTable_… objects per date column. Those don’t claim the literal name Calendar, so they weren’t the cause. You can try the following options.
1. Enable the View hidden option in the data pane, to view all tables. Maybe you will see the Calendar table then.
2. You can also use Tabular Editor to view all the tables in the model.
3. You may have created a calculation group called Calendar, which is preventing you from creating the Calendar table.
4. You may have create a Calendar view in Power Query and disabled it form loading. You then need to rename this view.
5. Lastly, when all else fails, you can save the Power BI report as a Power BI project (PBIP) file and then look in the *.SemanticModel\definition folder and open the model.tmdl with your favorite file editor. If the Calendar object exists, it should be defined in model.tmdl file.
Hope this helps. If so, please give a Kudos 👍 or mark as Accepted Solution ✔️.
The error happens because Power BI already has an internal “Calendar” table name reserved (often from the Auto date/time feature), so you cannot reuse that name even if you do not see the table in Fields.
How to fix
Turn off Auto date/time for this file (Options ➜ Current File ➜ Data Load ➜ uncheck “Auto date/time for new files”), close and reopen the report, then try again.
If it still fails, choose a slightly different name like CalendarTable, DimDate, or DateTable; these will work even when “Calendar” is blocked.
Hi Shubham_rai955, what you are saying is not correct. Power BI does not create an internal reserved table named Calendar when using the Auto date/time feature. Instead, it generates calculated tables whose names begin with "LocalDateTable" followed by a hash.