Forum Discussion
Helper IVImport 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
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.
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.
10 Replies
- danextian
Super User
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.
- rajendraongole1
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.
- pankajnamekar25
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 | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
v-sdhruvCommunity Support
Hi viswaaa ,
The error "unable to convert an M query in table Query1 into a native source query" usually means Power BI (or Power Query) cannot "fold" your M code back into a native SQL query for the underlying data source (like SQL Server, Snowflake, etc.)You can't change from Import to DirectQuery mode. You can switch from DirectQuery mode to Import mode if you import all the necessary data. It's not possible to switch back, mostly because of the feature set that DirectQuery doesn't support. DirectQuery models over multidimensional sources, like SAP BW, can't be switched from DirectQuery to Import mode either, because of the different treatment of external measures.
Refer-
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery#other-directquery-limitations
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You- danextian
It is possible to switch back to DQ using TMDL as long as the transformations applied can be folded back to the database.
- v-sdhruv
Hi viswaaa ,
Just wanted to check if you had the opportunity to review the suggestion provided?
Additionally you can visit this link to get more clarity-
https://community.fabric.microsoft.com/t5/Desktop/How-to-convert-a-power-bi-report-from-import-to-Direct-query/m-p/958735
If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank You
