Skip to content

Backend Modelling

Version

  • Tableau :
    • Only Tableau versions 2020.2 and above are supported

Features Supported

Data Source

  • Excel, Csv, Oracle Database, MSSQL server, PostgreSQL, MySQL,Terradata

Joins

  • inner join, left join, right join, full outer join

Backend Functions

  • Rename column

  • Change datatype

  • String Functions:

ASCII, CHAR, CONCAT, CONTAINS, ENDSWITH, FIND, LEFT, LEN, LOWER, LTRIM, MID, REPLACE, RIGHT, RTRIM, SPLIT,

STARTSWTH, TRIM, UPPER

  • Numeric Functions:

ABS, ACOS, ASIN, ATAN, ATAN2, CEILING, COS, DIV, EXP, FLOOR, LN, LOG, PI, POWER, ROUND, SIGN, SIN, SQRT, TAN

  • Date Time Functions:

DATEADD, DATEDIFF, DATENAME, DATEPART, DATETRUNC,

DAY, MONTH, NOW, QUARTER, TODAY, WEEK, YEAR

  • Type Conversion Functions:

DATE, DATETIME, FLOAT, INT, STR

  • Operators:

  • Arithmetic: +, -, *, /

  • Logical: AND, OR, NOT

  • Comparison: =, <>, <, >, <=, >=

  • Conditional Statements:

if, else, elseif

  • Storage mode:

Live, Extract

  • Custom SQL Query

Features Unsupported

  • In the case of multiple data sources modelled separately with a blend of relationships, the relationships will not be migrated to Power BI
  • If the Table name is not unique within a single workbook, Power BI throws an error
  • Transformations (includes conditions for success)
    • Spaces between keywords in an expression needs to be mandatory
    • Calculated fields with dimension columns from different tables
    • In calculating the difference between ‘Date’ and ‘Datetime’ column, the type needs to be the same
    • In Tableau, the values round to specific decimal values on calculated columns by default.
    • If Storage mode is Live in Tableau, Power BI (Direct query) does not support all the transformations.