web
You’re offline. This is a read only version of the page.
close
Skip to main content

Power BI

New

Date with no hierarchy with SSAS tabular live connection

Vote (10) Share
's profile image

on 19 Feb 2018 23:05:45

At the moment you do not support the bult-in date hierarchy when connecting to SSAS tabular or when using Direct Queries. That is fine as you built this hierarchy yourself in the tabular model (date, month, quarter, year, month + year etc.). However when connecting to your model, Power BI DOES NOT recognize the date hierarchy as a continuous variable (in stead as categorical variable). This means that a) you cannot apply trendlines under "Analytics pane" and b) more importantly when the system interpret the time as a categorical - it will always show a very annoying scroll bar (which it will not when continuous). Even EXCEL can always handle this - even when it is not recognize the data as dates. Put simply:

You cannot analyze time series data at all when using direct queries or connecting to a tabular live connection.

Comments (3)
's profile image Profile Picture

7c0b3015 1183-4b46-8df2-07ad5842aa76 on 06 Jul 2020 00:09:00

RE: Date with no hierarchy with SSAS tabular live connection

So important. Please resolve

's profile image Profile Picture

adb30dff 242c-4fb6-8edc-9ca073bfbd74 on 06 Jul 2020 00:04:09

RE: Date with no hierarchy with SSAS tabular live connection

Kind of workaround detailed here: https://community.powerbi.com/t5/Desktop/SSAS-Tabular-Date-Hierarchies-not-working-with-Live-Connection/m-p/864739/highlight/false#M414922

's profile image Profile Picture

adb30dff 242c-4fb6-8edc-9ca073bfbd74 on 06 Jul 2020 00:03:52

RE: Date with no hierarchy with SSAS tabular live connection

Hi

This is fundamental you our, and I'm guessing lots of companies, needs.