Skip to main content

    Power BI

    Needs Votes

    Set connection mode direct query per table

    Vote (15) Share
    Salvatore Cagliari's profile image

    Salvatore Cagliari on 18 Apr 2016 18:36:13

    In PowerBI Desktop it looks like, that when you set DirectQuery or Import for one table from one source (e.g. SQL Server instance), all tables from this source are set to the same mode.
    It would be great to have to possibility to set some (e.g. Dimension) tables to Import and other (e.g. Facts) as Direct Query

    Comments (1)
    Salvatore Cagliari's profile image Profile Picture

    Ivan Tamburic on 05 Jul 2020 22:37:13

    RE: Set connection mode direct query per table

    '+1. Similary like Tableau data blending.