Skip to main content

    Power BI

    New

    Please give a option to change a report from Import Mode to Direct Query Report

    Vote (42) Share
    Ramana Chandaka's profile image

    Ramana Chandaka on 20 Sep 2018 17:25:01

    If there is a option for changing from Import Mode to direct Query mode reports it will be a great help for developers because if datasets having huge data the import mode reports are taking lot of time to apply query changes. We already have a option from Direct Query to Import Mode.

    Comments (3)
    Ramana Chandaka's profile image Profile Picture

    dbd9b92d 8010-4a1d-af1e-1610685e655c on 06 Jul 2020 00:05:44

    RE: Please give a option to change a report from Import Mode to Direct Query Report

    Tableau allows this (Extract to Live)

    Ramana Chandaka's profile image Profile Picture

    dbd9b92d 8010-4a1d-af1e-1610685e655c on 06 Jul 2020 00:05:31

    RE: Please give a option to change a report from Import Mode to Direct Query Report

    Hello, I fully support this idea! Especially if there is no further PowerQuery modification beside the connect step I don't see why it shouldn't be possible to toogle back from import to direct query. Big advantage would be to NOT rebuild all relationships and RLS settings - which is a hell of (none value adding) work in big datasets.

    Ramana Chandaka's profile image Profile Picture

    6287c412 746b-4893-9b18-5038b7c7f756 on 05 Jul 2020 23:50:15

    RE: Please give a option to change a report from Import Mode to Direct Query Report

    Due to many features in Import mode that are not supported in the DirectQuery mode, it’s not possible to switch from Import Mode to DirectQuery Mode.

    However, you can check the available workarounds at https://spgeeks.devoworx.com/switch-import-to-directquery-mode-powerbi/