Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Help expanding tester

Hello all,  I am trying to retrieve the latest outcome for a given test plan and the tester who ran the test.  I am able to retrieve the results, however the Tester value is 'Record' (the field needs...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

The error message indicates that the query specified in the URI is not valid[5]. The error message also suggests that the Analytics Service doesn't support key or property navigation like WorkItems(Id) or WorkItem(Id)/AssignedTo. If you are getting that error in PowerBI, please rewrite your query to avoid incorrect folding that causes N+1 problem.

You can try to rewrite your query to avoid incorrect folding that causes N+1 problem. You can also try to use the OData.Feed function to retrieve the Tester's User Name.

 

You can go through this article to know available OData query string options.

 

On Power BI side, to get the data use Odata feed data source, for example Dynamics CRM, you can take a look at this article: Prefilter data for Power BI with OData URLs. The entered URL should follow the syntax of above OData URI.

 

Maybe you are also interested in Filter a report with a URL query string parameter.

 

                                                                                                                                                         

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.