Forum Discussion

rdg515's avatar
rdg515
Icon for Resolver I rankResolver I
6 years ago

Data Flows - How to limit data in Power BI Desktop

I have a large data set that I intend to create as a Data Flow.  I am frequently adding fields to the data set, and would like to be able to work with this data set in Power BI without having to down...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
6 years ago

" 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's avatar
rdg515
Icon for Resolver I rankResolver I
6 years ago

Minimize UI response time / DAX calculation time is the primary concern because of all the data and complexity of the model.

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    6 years ago

    Then you need to either go with the wasteful option, or look into a hybrid scenario with aggregations that cover the inital UX  (initial visual renders).  And of course you will want to examine all your measures with DAX Studio.