Forum Discussion

Srikanth7Gunnam's avatar
Srikanth7Gunnam
Helper I
5 years ago

Filter and pulling few columns from Dataflow in Power Query

Hello, I am writing this post to check whether we can achieve the following scenario in Power Query or not. I have created a data flow with more than 30 columns that can be used for multiple reports...
General Comment
Need Help
Show and Tell
Tips and Tricks
mahoneypat's avatar
mahoneypat
Microsoft Employee
5 years ago

Yes.  Choose Power BI Dataflows as your source/connector, navigate to your Dataflow, and then click on Choose Columns in the ribbon.

Pat

 

Srikanth7Gunnam's avatar
Srikanth7Gunnam
Helper I
5 years ago

Hello Pat,

Thank you for your response. But, I don't want to import the entire data flow and choose columns or apply a filter. What I want to do is out of 30 columns in the dataflow pull only specified columns and apply a filter like where column1 = USA. 

Thanks,
Sri

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    5 years ago

    As far as I know, Dataflows don't yet "fold" (push the filter/select back to the source), so each refresh will bring in the full data and then you reduce it from there.  I hope that changes soon.

    Regards,

    Pat

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    Hi Srikanth7Gunnam ,

    If you do not want to import all the data into power query from dataflows, you can filter it directly in dataflows, then connect to it in power query.

    The steps you have filtered data in dataflows are the same as in power query, like remove unnecessart columns, filter specific values etc.

     

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Srikanth7Gunnam's avatar
      Srikanth7Gunnam
      Helper I
      5 years ago

      Hello,

      Thank you for your reply. But, my data flow is a centralized data source for multiple reports. I can't filters in the dataflow as it has data about all the countries and I have reports for each country individually. So, I want to fold the query while importing. Can you please tell me whether we can do it or not?

      • v-yingjl's avatar
        v-yingjl
        Community Support
        5 years ago

        Hi Srikanth7Gunnam ,

        As far as I know, when accessing dataflow entities from Power BI Desktop, no query folding takes place, even if the enhanced compute engine is enabled. Please refer this article: Power BI dataflows and query folding 

         

        Perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/forums/265200-power-bi-ideas

         

        Best Regards,
        Community Support Team _ Yingjie Li
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.