Forum Discussion
Solved
Direct query vs Import Mode when complex DAX is used
Hello Everyone, I’m currently using Dataflows to build my visualizations and reports. Each report automatically creates a semantic model that includes the same data from the Dataflow, plus any ad...
julsr One option would be to simply take your dataflow Power Query code and use that in your import queries. Then you are just refreshing a single time. The other option would be to land your dataflows in a Fabric warehouse/lakehouse and use Direct Lake. DirectQuery is going to be limited and slow. Direct Lake should be comparable to import but somewhat slower.
Thank you all! Everyone gave me insights on how to solve this problem!