Forum Discussion
Resolver IData Flows - How to limit data in Power BI Desktop
Resolver ISorry, 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
Super User" 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?