Limit copying direct query to other table

[Heinrich]

Hello

Are there any limits copying direct query to other table (imported)

How could I disable the limitation?
Regards
Heinrich

[Anonymous]

Hi @Heinrich ,

Could you please confirm if the issue has been resolved on your end? If a solution has been found, it would be greatly appreciated if you could share your insights with the community. This would be helpful for other members who may encounter similar issues.
Thank you for your understanding and assistance.

[Anonymous]

Hi @Heinrich ,
May I ask if you have gotten this issue resolved?
If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members in the community who have similar problems as yours to solve it faster.
Thank you.

[Heinrich]

Hello @Anonymous 
Thank you very much. Sorry for the delay
Have a great day

[Akash_Varuna · Accepted solution]

Hi @Heinrich  There are limitations when copying data from a DirectQuery table, such as those from Microsoft CQD, into an imported table using DAX. DirectQuery does not allow directly materializing data into an imported table within Power BI. To bypass this, you can use Power Query to reference and load the required data in Import Mode, set up a Dataflow to transform and store the data for import, or export the data from CQD and re-import it into Power BI as a static table.

[Heinrich]

Hello @Akash_Varuna 
Thank you but SQL view requires a SQL Database right? It is not possible
What would be Hybrid model? Also mix between SQL and Power Direct Query?
That is also not possible
Are there any other solutions.

Thank you

Heinrich

[Akash_Varuna]

@Heinrich What is your data source ?

[Heinrich]

My data source is Microsoft CQD and Direct Query.

[danextian]

Hi @Heinrich 

When you say "copying," are you referring to appending or merging it with an imported table? If so, that breaks query folding, which means DirectQuery will no longer be supported.

[Heinrich]

Hello @danextian 
With copying I mean a DAX code which refers to the Direct Query Table and copy to New Import Table
Regards
Heinrich

[Akash_Varuna]

Hi @Heinrich  DirectQuery tables can't be directly copied to imported tables due to modeling and performance restrictions. You can't merge or append DirectQuery with imported data. To work around this, consider using a Hybrid model or create SQL views at the data source level to combine both. For more details, check the  
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about?source=recommendat...