https://community.fabric.microsoft.com/t5/Developer/Rest-API-date-hierarchy/m-p/955245#M22543 <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/186768">@jakubpetr</a>&nbsp;Date hierarchy is created at model level (not dataset level). And it's done by marking a table (typically a calendar table) as a Date Table. You should always turn off the time intelligence setting in the options of each PBIX file (option is called Auto date/time).&nbsp;</P> Mon, 02 Mar 2020 13:00:33 GMT JirkaZ 2020-03-02T13:00:33Z https://community.fabric.microsoft.com/t5/Developer/Rest-API-date-hierarchy/m-p/951294#M22520 <P>I can create datetime via rest api, push data, it shows as pm/am (indicating it loaded data correctly).</P><P>What I cannot is create Date hierarchy, such as here&nbsp;<A href="https://5minutebi.com/2017/11/29/how-to-use-powerbi-date-hierarchy/" target="_blank" rel="noopener">https://5minutebi.com/2017/11/29/how-to-use-powerbi-date-hierarchy/</A>. If I use excel and import data as csv, the date hierarchy is created automatically.</P><P>Any hint on how to use DateTime as Date hierarchy? Is it even possible?</P> Thu, 27 Feb 2020 16:30:01 GMT https://community.fabric.microsoft.com/t5/Developer/Rest-API-date-hierarchy/m-p/951294#M22520 jakubpetr 2020-02-27T16:30:01Z https://community.fabric.microsoft.com/t5/Developer/Rest-API-date-hierarchy/m-p/955245#M22543 <P><a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/186768">@jakubpetr</a>&nbsp;Date hierarchy is created at model level (not dataset level). And it's done by marking a table (typically a calendar table) as a Date Table. You should always turn off the time intelligence setting in the options of each PBIX file (option is called Auto date/time).&nbsp;</P> Mon, 02 Mar 2020 13:00:33 GMT https://community.fabric.microsoft.com/t5/Developer/Rest-API-date-hierarchy/m-p/955245#M22543 JirkaZ 2020-03-02T13:00:33Z