Forum Discussion

DebbieE's avatar
DebbieE
Community Champion
6 years ago
Solved

Incremental Refresh Via dataflows, and creating the data set in Desktop

Say you have Power BI Premium and you have a large data set consisting of 10 years of data   You create all the Power Query modelling in Dataflows and then you set up incremental processing on thes...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi DebbieE ,

     

    After you publish a dataset which connect dataflow and filter some data in power query editor, the dataset in service will be the filtered data from the dataflow(the source data is dataflow in workspace, with addition queries defined in desktop), such as following.

     

     

    If you want to make report with filtered data in desktop but keep all the data after publishing to Power BI Service, we can delete the query which filtered the table before we published the report.

     


    Best regards,

     

v-lid-msft's avatar
v-lid-msft
Community Support
6 years ago

Hi DebbieE ,

 

After you publish a dataset which connect dataflow and filter some data in power query editor, the dataset in service will be the filtered data from the dataflow(the source data is dataflow in workspace, with addition queries defined in desktop), such as following.

 

 

If you want to make report with filtered data in desktop but keep all the data after publishing to Power BI Service, we can delete the query which filtered the table before we published the report.

 


Best regards,