Forum Discussion

rmit0422's avatar
rmit0422
New Member
8 months ago
Solved

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 anythi...
  • nielsvdc's avatar
    8 months ago

    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 ✔️.