Forum Discussion
keithpoplar
10 years agoFrequent 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.
No RepliesBe the first to reply