Forum Discussion

ReadTheIron's avatar
ReadTheIron
Helper III
1 year ago

Can't use left anti join with DirectQuery

I have a very large table ("All Failures") I'm connected to with DirectQuery. I'm trying to filter these records so as to exclude the ones that appear on a much smaller list ("Disqualified Failures")...
Need Help
Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi ReadTheIron ,

 

According to your statement, I think you want to to filter your table when you load it from your databased by Direct Query connection mode.

As far as I know, there are some limitation on data transformation in Direct Query.

For reference: DirectQuery in Power BI - Power BI | Microsoft Learn

I suggest you to add SQL statement in advance options.

Or you may load tables and then create relatioship between the fact table and the small table.

Then create the visual by key columns in small table.

 

Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

ReadTheIron's avatar
ReadTheIron
Helper III
1 year ago

I'm afraid I don't know what to do with SQL statement in advance options, and it's not just one visual I want to create with the filtered table, it's all the visuals in my report. Thanks for answering though!