Forum Discussion

viswaaa's avatar
viswaaa
Icon for Helper IV rankHelper IV
1 year ago
Solved

Import to direct query mode

Hi Team,   I created a report using import mode, and I want to change that a direct query. Could anyone suggest how to change this
Need Help
  • rajendraongole1's avatar
    rajendraongole1
    1 year ago

    Hi viswaaa  - Unfortunately, you cannot directly switch a Power BI report from Import mode to DirectQuery mode.

    again, you have to rebuilding the model using DirectQuery.

     

    suggest, You can open both your old (Import) and new (DirectQuery) files side by side to copy DAX, visuals, and structure more easily for quick implementation.

     

    Hope the above information helps.

  • danextian's avatar
    danextian
    1 year ago

    This means the transformation cannot be folded back to the source database. So, even if you switch back to DirectQuery, you must either remove the steps that break query folding or modify them to use operations that support it. Note: not all Power Query transformations have a DirectQuery-compatible equivalent.

pankajnamekar25's avatar
pankajnamekar25
Icon for Super User rankSuper User
1 year ago

Hello viswaaa 

Open your existing .pbix file.

 Go to Home > Transform data > Data source settings.

 Clear permissions for the source (optional, if you want to reconnect).

 In Power Query, remove the imported tables.

 Go to Home > Get Data, connect to your data source again.

This time, choose DirectQuery instead of Import.

 Rebuild relationships and visuals (if needed).

 

You can explore details here

Solved: How do I change a query from Import to Direct Quer... - Microsoft Fabric Community

Thanks,
 Pankaj Namekar | LinkedIn

If this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.