Forum Discussion
Helper IIAppend Query with DirectQuery mode
Hi stalerik ,
Greg is right. It is not supported for DQ mode to append tables in Power Query and create calculated tables with DAX. As you tried, it is always changing to composite models. For now, there is not a good workaround to solve it. I think you could reference the document: Use composite models in Power BI Desktop to check if it is okay using the models. For composite mode, your original tables remained in DirectQuery mode and just the new tables with import mode.
You could reference the documents to learn more about DirectQuery.
About using DirectQuery in Power BI
Use DirectQuery in Power BI Desktop
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi stalerik ,
Greg is right. It is not supported for DQ mode to append tables in Power Query and create calculated tables with DAX. As you tried, it is always changing to composite models. For now, there is not a good workaround to solve it. I think you could reference the document: Use composite models in Power BI Desktop to check if it is okay using the models. For composite mode, your original tables remained in DirectQuery mode and just the new tables with import mode.
You could reference the documents to learn more about DirectQuery.
About using DirectQuery in Power BI
Use DirectQuery in Power BI Desktop
Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.