Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dataflow +Dataset = NEED more Clarity!

Hi All, I have successfully built an Enterprise Dataflow that loads all my tables in PBI service. Its incremental, scheduled and all is good! Now I use PowerBI Desktop to consume my Dataflow: PS: I...
dataflow
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thanks. But the problem is every-time you switch it starts downloading the data again right?

jeffshieldsdev's avatar
jeffshieldsdev
Icon for Solution Sage rankSolution Sage
6 years ago

Correct, Anonymous you'll eventually need to download all the data to Desktop to publish--but at least this eases report creation.

 

I'm pretty sure DirectQuery is coming to Enhanced Dataflows Compute Engine, so maybe there will be options to limit data during report creation too :)

 

EDIT: Actually, no--you don't have to download everything to Desktop if you don't remove the filter from the derived Dataflow until after publish.  From MatthewRoche 's blog

 

"Quick Tip: Developing with large dataflows

  1. Develop and test the dataflows in the Power BI service
  2. Add filters to the too-large dataflow entities’ queries[2] to reduce the number of records in the entities
  3. Refresh the dataflow
  4. Develop the model and reports in Power BI Desktop
  5. Publish the model and reports to the Power BI service
  6. Remove the filters from the filtered dataflow entities
  7. Refresh the dataflow
  8. Refresh the dataset"
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    jeffshieldsdevThank you so much! This sounds promising! :)

    Sad we have to beat around bushes to find such solution. Wish MS made it clear from day 1.

    Also happy to hear DirectQuery is coming to Dataflows!
    However, is the DirectQuery from the data loaded to a Flow?
    Or DirectQuery from the source DB via Dataflow?