Skip to main content

    Power BI

    Needs Votes

    Improve Querying performance to SQL Sever Analysis Services with large data

    Vote (22) Share
    Power BI User's profile image

    Power BI User on 14 Feb 2017 11:05:02

    Especially Tabular Models with large volume suffer from the quality of MDX generated by PowerQuery component. For example, the same queries made in Excel Pivottable are most of the time faster with a better MDX generation. Also, why not querying tabular models with DAX ! previewing queries with a subset are very slow in case of use of high cardinality attributes