Forum Discussion
Table Name Duplicate Error
Hello,
I am trying to make a table called Calendar for my Power Bi report and it says Calendar is already used for a table. I checked all my tables and none of them are named Calendars or anything similar. I went to setings and turned Auto date/time off, restarted Power Bi desktopp, tried renaming the table again adn same result. I also tried renaming the table to something else and tried to make a new Calendars table with the same error. Any suggestions?
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 ✔️.
6 Replies
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 ✔️.
You may also want to look at this post that discussed a similar issue.
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.
Hi rmit0422 ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.Thank you.
