Forum Discussion

Anonymous

Not applicable

6 years ago

Filtering lines from data table based on values in exclude table

Hello, I'd like some help getting pointed in the right direction. I am new to Power BI but trying to learn and absorb as much as possible by reading books, watching videos, experimenting and aski...

Need Help

Jimmy801

Community Champion

6 years ago

Hello Anonymous ,

if it's working for you its fine. And if the performance is okay.

The downside of only using this, is that you have to import the whole data even if you don't need all of it.

With power query you could limit the amount of data in your data model and depending on your data source is taking place query folding, meaning you get from the datasource only the lines you need.

But if your solution is working, I wouldn't change it.

If this post helps or solves your problem, please mark it as solution.
Kudos are nice to - thanks
Have fun

Jimmy

Anonymous

Not applicable

6 years ago

Thanks again for the feedback. So, I wanted to try it with the Power Query method you mention. Doing some studying, I found that the "Group By" functionality held some promise. After working at it for a bit, I came up with the below request and the resultant table which looks correct. Although, I will admit the "min" request on the boolean column of is_valid seems wrong.

Any thoughts on this? I next attempted to use this reduced data in my model and found that it works. I applied the same filter on all pages shown earlier and had no trouble. However, I did encounter one oddity. I simply wanted to display the data in this new table and I now get an error when trying to include the md5 in the table. It looks like this: