In this blog you will understand – “How you can remove default date hierarchy from import mode dataset in Power BI”.
When you load any dataset using import mode, Power BI automatically create a date hierarchy for all existing date fields under that dataset. See the below given screen shot-
By default this date hierarchy features is enable for import mode, but you can stop this feature by using some changes on Power BI desktop file settings.
Follow the below steps-
Go to File –> Options and Settings –> Options –> Current File -> Data Load
and turn off ‘Auto Date/Time’ (under Time Intelligence)
Now you can see the date field, date hierarchy has been disable.
Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.