Forum Discussion
Resolver IData Flows - How to limit data in Power BI Desktop
Resolver IAre you saying doing the import from the data flow duplicates / wastes space? Won't an import provide improved performance vs a direct query? That is typically the case. Is it different for a Data Flow?
Super UserYes, that's what I am saying. Using Dataflows as a source in Import mode is not just wasting space, it is also wasting time as you need to first refresh the dataflow and then refresh the dataset.
Mind you, until very recently this was our only option. Direct Query against Dataflows was only made available a few months ago.
- rdg515
Sorry, I want to make sure I fully undestand because you didn't address my question concerning performance. It's my assumption that direct query is always slower than imports. Is this a correct assumption, even with Direct Query against Data Flows in the Service?
If that's a correct assumption, and I find that the performance is too slow, what are my options?
1) Create summarized queries (same recourse when working with Direct Query in general)
2) Not use Data Flows because it would just be duplicating data
- lbendlin
" It's my assumption that direct query is always slower than imports. "
That's too ambiguous. You need to differentiate between developer performance and end user performance. What is your goal? Do you want to minimize dataset refresh times or do you want to minimize UI response times?
- rdg515
Minimize UI response time / DAX calculation time is the primary concern because of all the data and complexity of the model.