Hide local date table in PBI analyze with Excel

[AO_Monica]

Hi,

When I connect to PowerPlatform data to create a pivot table from the existing PBI dashboard, I started seeing these localdate tables showing in the excel pivot table.

How do I remove/hide these localdate tables?

[Anonymous]

Hi @AO_Monica ,

Whether the advice given by SamWiseOwl  has solved your confusion, if the problem has been solved you can mark the reply for the standard answer to help the other members find it more quickly. If not, please point it out.

Best Regards,

Neeko Tang

[SamWiseOwl]

Hi @AO_Monica 

These are generated by Power BI using this setting in Power BI:

You can turn this off Globally or for the Current file only.

If you are turning this off make sure you have create a calendar table to use in your date time calculations.

https://www.wiseowl.co.uk/blog/s2947/calendarauto-table.htm

You can see here my two date columns in PBI have the auto calendar tables turned on: