filter condition in GET activity events not working in power query M

[Bsovi]

Hi, 

I've run api call in Power M query to get the activity events filter by ViewReport.

But instead return only ViewReport, it returned all the activity. Please see below screen-shot.

Is anyone can let me know, what did I do wrong here?

thanks.

[Daryl-Lynch-Bzy · Accepted solution]

Hi @Bsovi - It is a bit hard to make out, but I think there is "&" missing in the String "$filter=Activity eq 'ViewReport'".  So i think the relative path is not picking this up as an "AND" condition.  It might be ignoring it?

Many thanks

Daryl

[Bsovi]

Hi Daryl,

you have an eagle eyes, catching this :).

I actually check a few times, but still did not catch the incorrect part :).

thanks a lot.