Home Dashboard Directory Help
Search

Tabular DAX Measure Not Available in Power View Field List by Dan English


Status: 

Active


11
0
Sign in
to vote
Type: Bug
ID: 784965
Opened: 4/17/2013 2:47:45 PM
Access Restriction: Public
0
Workaround(s)
view
1
User(s) can reproduce this bug

Description

Trying to create a Power View report in SharePoint off a Tabular SSAS source. There are two measures in the data model that do not display in the Field List. These do show up in Excel with PivotTables as well as in SSMS if I query the database. One measure is returning a date and the other is a string (a number formatted for readability).
Details
Sign in to post a comment.
Posted by SLSData on 6/4/2014 at 3:24 PM
I have SharePoint 2013 with a Power View report accessing an SSAS 2012 tabular model in Direct Query mode. All of my measures present in Power View except those referencing a date column. They are very simple measures referring to a SQL backend data source. Is there a Power View limitation that I need to know about? Since Power View is the only tool available for Direct Query mode, this is critical to my project.

Oldest Date:=MIN([alarm_date])

Test Date:=DATE(2014,06,04)

My tabular model is Direct Query Only mode and currently, according to MicroSoft, Power View is my only reporting option. Further research shows that this bug may have been reported earlier than Dan's post this year. More like 10/4/2012. This is a serious issue for my project as my design is centered around Direct Query mode. It is shameful for Microsoft to knowingly market solutions that have critical and fundamental lapses in functionality.
Sign in to post a workaround.