Idea Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
0
Improvements needed to the DAX editor in SSAS Tabular
Submitted by
Paul114
on
02-03-2015
05:58 PM
Many developers abandon SSAS Tabular (after their companies pay for enterprise licensing to get it) because of the development experience and they reason that if the development experience is poor that the product may be just as unreliable. The model designer has many problems and quirky behaviors when the model becomes complex (typically due to the number of tables & measures). In particular, the DAX editor can be very unwieldy. The auto-completion feature can cause more mistakes than it prevents. For example, if you were to backspace over a table and column, and then use the object list to select a different object; the editor makes a horrible mess by combing the old and new text. Some examples: In trying to replace 'First Table'[First Column] with 'Second Table'[Second Column] the editor may produce: 'First Table'[First Co[Second Column]lumn] or ''Second Table'[Second Column]. Given the small font and text size in the editor, users miss the doubled-up single quotes. When an error is reported, changes are lost; developers become angry & moody and are mean to people around them. After making changes to an expression and pressing Enter to save changes, the editor shows the previous expression, causing the developer to think that changes were lost which makes them throw things and use bad words. While you're at it, add support for comments and tabs. I suggest a usability test be conducted and observed using a production-scale project.
See more ideas labeled with:
Comments
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Latest Comments
- merramun on: Ability to change slicer border color
-
EHA_SD
on: :Don't add aggregation in front of each field name...
-
frithjof_v on: Hide secrets and keys - API - Power Query
- UlrikH on: Power BI - Org apps and cross-report drillthrough
-
NaamaTsafrir on: Apply Tag to workspaces
-
pacifist
on: Power BI | Enable or Disable all datasets Refreshe...
- M_GE on: Page-Level security in reports
- Matt_Benham on: Increase pipeline max activities + fix lakehouse d...
- leyre on: Multi-window support for Power Bi Desktop
- amandashinkawa on: PowerBI: Sticky Elements for Vertical Scroll Dashb...
Idea Statuses
- New 14,850
- Need Clarification 2
- Needs Votes 22,625
- Under Review 619
- Planned 251
- Completed 1,643
- Declined 220
-
Power BI
38,607 -
Fabric platform
524 -
Data Factory
441 -
Data Factory | Data Pipeline
273 -
Data Engineering
245 -
Data Warehouse
174 -
Data Factory | Dataflow
144 -
Real-Time Intelligence
127 -
Fabric platform | OneLake
105 -
Fabric platform | Workspaces
104 -
Fabric platform | Admin
102 -
Fabric platform | CICD
80 -
Fabric platform | Capacities
59 -
Real-Time Intelligence | Eventhouse and KQL
57 -
Real-Time Intelligence | Activator
51 -
Fabric platform | Security
42 -
Data Science
41 -
Fabric platform | Governance
40 -
Data Factory | Mirroring
36 -
Fabric platform | Support
30 -
Real-Time Intelligence | Eventstream
30 -
Fabric platform | Data hub
26 -
Databases | SQL Database
24 -
Databases
20 -
Data Factory | Apache Airflow Job
3 -
Product
2 -
Fabric platform | Real-Time hub
1 -
Real-Time Hub
1