Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 Time Intelligence -> Auto Date/Time done. checked and it works to reduce the data size.
i want to ask about is there any impact on Time Intelligence related queries / views etc. AND
please advise in what situations we can or cannot uncheck this option?
regards
Solved! Go to Solution.
@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
@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
User | Count |
---|---|
89 | |
88 | |
75 | |
67 | |
58 |
User | Count |
---|---|
137 | |
110 | |
91 | |
84 | |
69 |