cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
keithpoplar
Frequent Visitor

JavaScript sdk date time filter

I downloaded Power BI angular client sample (https://github.com/Azure-Samples/powerbi-angular-client) and try to implement an advanced filter in the hosting application to filter my report by date time.

 

It didn't work. The server returns this error: Object {message: "Invalid filter definition"}

 

Below is the code segment for advanced filter:

 

    static predefinedFilter2 = new pbi.models.AdvancedFilter({
        table: "f_msANA_byRelease_transformed",
        column: "aaValuePeriodStartTime"
    }, "And",
        {
            operator: "GreaterThan",
            value: "2016-06-01"
        }
    );

I tried to change the date time to different format but hit the same error.

 

Any suggestion is appreciated.

0 REPLIES 0

Helpful resources

Announcements
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Kudoed Authors