Forum Discussion
Reduce Data size in pbix...
hi all, i saw a video guide (Guy in a Cube) link below, he guide to reduce size of data by unchecking an option File -> Options and Settings -> Options then under CURRENT FILE -> Data Load under Tim...
Anonymous , Once you uncheck all Default Date Hierarchies will go away. You will not [Date].Year or [Date].month etc
You have to use a new column year([Date])
I personally create a date table with all columns I need and add a custom hierarchy as per need .
You should be able to use most of the time intelligence function without date hierarchy. You can use excat columns if needed
thanks amitchandak it means we can un-check this option before loading data to reduce the data size? or i misunderstood ?
regards
ok, then i will un-check that opiton to reduce data size and use new column year([Date]) for most of the requirements.
regards