Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

mrmick69

SSAS Tabular Live Connection - PowerBI will not recognize dates as dates

Submitted by on ‎09-14-2017 08:37 AM

We have a SSAS Tabular data model (SQL Server 2014) that we connect to via a Live Connection in PowerBI. The data model has a date table that is marked as a Date Table and a properly selected date identification column. The properties for the date column are set as date.

image.png

image.png

 

PowerBI will not recognize the Date column as a date, thus it will not engage PowerBI's date features. 

 

Status: Needs Info
See more ideas labeled with:
3 Comments (3 New)
Comments
v-haibl-msft
Microsoft Employee
Microsoft Employee
‎09-15-2017 02:12 AM

@mrmick69

 

What is the Power BI date features are you using? I just have a try on my side but cannot repro the same. The date column can be recognized properly as following screenshot.

 

SSAS Tabular Live Connection - PowerBI will not recognize dates as dates_1.jpg

 

Best Regards,
Herbert

Vicky_Song
Impactful Individual
Impactful Individual
‎09-15-2017 02:14 AM
Status changed to: Needs Info
 
Anonymous
Not applicable
‎02-13-2018 12:57 AM

Power BI does not recognise date from SSAS tabular models and create a proper hierarchy. This is a huge drawback for our organisation as well. Line charts looks awful, they do not scale properly and we cannot use trend lines. 

I do not know if this is a problem with Power BI or SSAS, but I have read that it works for SSAS cubes, but not tabular models.

 

You kan vote for the idea here:
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10989855-enable-ssas-and-date-hie...

 

Idea Statuses