Skip to main content

    Power BI

    Needs Votes

    Enable selecting the table/dimesions/facts in ssas tabular import mode

    Vote (2) Share
    ajil jins's profile image

    ajil jins on 26 Jul 2017 16:40:57

    Import Mode with SSAS not allowing selecting individual objects(tables/dimensions/facts). At model level it does a cross join of all attributes. Manually we need to transform this query and add required columns/table, then to manually define the relationships. Though Live mode is recommended for SSAS source, for data mash up we need these options in import mode as the default cross join behavior needs lot of effort to split each and every tabular objects.