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?