Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
akagiz
Frequent Visitor

Power BI Embedded OData filter "or" operator

Hi there

 

i am developing an asp.net mvc webapp that is integrating Power BI Embedded, which works just fine.

I want to filter the DataSet with an oDataFilter like that:

    load: function () {
        var computedStyle = window.getComputedStyle(this.element);
        var accessToken = this.getAccessToken();

        var initEventArgs = {
            message: {
                action: this.options.loadAction,
                accessToken: accessToken,
                oDataFilter: "Metrics/project eq 'auth'",
                width: computedStyle.width,
                height: computedStyle.height
            }
        };

        powerbi.utils.raiseCustomEvent(this.element, 'embed-init', initEventArgs);
        this.iframe.contentWindow.postMessage(JSON.stringify(initEventArgs.message), '*');
    }

This works like it should, i just get records which have the value "auth" in the row "project". However when i am extending the oDataFilter like that:

...
oDataFilter: "Metrics/project eq 'auth' or Metrics/project eq 'beta'",
...

I expect to get rows that have either the value "auth" or the value "beta" in the row "project". But it now completely disregards the filter passed to it and gives me all the records in that DataSet.

 

How do i achieve that particular filter scenario?

Greetings

0 REPLIES 0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.