Tables appearing in Tabular Editor that are not in my Composite model

[daxreport]

I am using a Composite model. When I connect to tools like Tabulor Editor or Dax Studio, I am seeing tables (named like LocalDateTable) that are not in my actual model. There are a few of these and I am not where these are originating from and if there is truly a reason that they exist in these tools.

In my actual model, there is only one data table (DIM_CALENDAR) but in Tabulor editor that only has a "Date" column and not the hierarchy that I see in my model. Any insights would be appreciated. Thank! 

[v-jingzhang]

Hi @daxreport 

@az38 's reply is correct. You can find more description about this feature from the official document Auto date/time in Power BI Desktop

The auto date/time is a data load option in Power BI Desktop. The purpose of this option is to support convenient time intelligence reporting based on date columns loaded into a model. Specifically, it allows report authors using your data model to filter, group, and drill down by using calendar time periods (years, quarters, months, and days). What's important is that you don't need to explicitly develop these time intelligence capabilities.

When the option is enabled, Power BI Desktop creates a hidden auto date/time table for each date column, providing all of the following conditions are true:

• The table storage mode is Import
• The column data type is date or date/time
• The column isn't the "many" side of a model relationship

These hidden auto date/time tables will enlarge the model size. If you have developed your own date table in the model, or you want to reduce the size of the model, or you don't need this feature, you can turn if off for a single report or at the global scope on your computer. Auto date/time guidance in Power BI Desktop

When you use tools like Tabulor Editor or Dax Studio to connect to a report, all visible and hidden tables in the model will be displayed. That's why you see those "LocalDateTable_xxxxxxxxxx" tables. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[daxreport]

Thanks @v-jingzhang & @az38 for the response!

I turned off auto date/time in both Global settings as well as at the report level. However, these auto-generated tables are still there in DAX Studio. I will note that the storage mode is not IMPORT. It was originally a live connection to a PowerBI Dataset (shared by IT) and then I changed it to a DirectQuery/Composite model. 

Could this be due to the fact that this is a PBI Dataset in Directquery mode and not IMPORT? Is there any alternate way to remove them?

Thanks, 

Dhairya 

[v-jingzhang · Accepted solution]

Hi @daxreport 

Yes, you are correct. As this is a Power BI dataset shared with you, you are not able to modify the model or tables in this dataset. Only the dataset author can modify it. If you don't want these tables, you will need to ask the IT to modify this setting in Power BI Desktop for the old dataset and republish it to Power BI Service. Then share the new dataset with you. This setting cannot be modified in Power BI Service.

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[daxreport]

Makes sense, thanks!

[az38]

Hi, @daxreport 

it is automatically created date tables.

to avoid this try to turn off "Auto date/time" feature in Parameters - Global - Data Load