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
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?