PowerQuery Ignores Relationships

[Anonymous]

Hi,

I am using a DirectQuery where the data model is made up of View that I have created the relationships with in power bi. It's just a classic star schema.

I create in PowerBI a table with a series of filters from the Dimensions. the Filters apply correctly in Power BI.

When I attempt the same thing in Excel then it ignores the filters and tries to load everything in my Fact table.

[Anonymous · Accepted solution]

I have manged to resolve this bug changing the value I want to be a metric. This then seems to work If I need to apply filters to the metric values. It doesn't however if I do it for non-metric values  (for example I just want to see the filter dimensions on my fact table)

[v-deddai1-msft]

Hi @Anonymous ,

How did you set filter in power query? Would you please show us some screenshot?

Best Regards,

Dedmon Dai