Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
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.
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 2 | |
| 1 | |
| 1 |
| User | Count |
|---|---|
| 5 | |
| 5 | |
| 4 | |
| 4 | |
| 3 |