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.
Hi julsr ,
Could you provide an update on your issue? Please review the helpful information shared by the community members GeraldGEmerick lbendlin and let us know if you need more details or further assistance.
Thank you for your response, GeraldGEmerick and lbendlin .