Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

PowerQuery Ignores Relationships

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.

Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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)

2 Replies

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Community Support
    5 years ago

    Hi Anonymous ,

     

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

     

    Best Regards,

    Dedmon Dai

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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)