I'm fetching data from Azure Devops using an OData connection (+ a previous extraction using API calls to Azure Devops running on PowerShell, that creates a plain file that gets uploaded into a Sharefile folder).
This is good for aggregated data reports, but what about when we want to check for example, an specific test plan id in Azure Devops? I have tried to use this initial connection to get a list of the test plans available, so that when one of them is selected, the rest of the information is then fetched real time, but to no avail. Is this even possible?
This brings over the list of test plans id:
= OData.Feed("https://analytics.dev.azure.com/SomeOrganization/_odata/v3.0-preview/WorkItems?" & "&$filter=WorkItemType eq 'Test Plan'" & "&$select=WorkItemId", null, [Implementation="2.0"])
I can also bring some information from a specific hard coded test plan:
= OData.Feed("https://analytics.dev.azure.com/SomeOrganization/_odata/v3.0-preview/WorkItems?"
&"&$filter=WorkItemId eq 28300"
&"&$select=WorkItemId,WorkItemType,Title,State,Claro_ALM_TipoServicioPruebas,Claro_ALM_OrdenTrabajoId,Claro_ALM_TareaSolicitudPruebasId"&"&$expand=Claro_ALM_Asignado($select=UserName),Area($select=AreaName)", null, [Implementation="2.0"])
But when I want to use a parameter like:
testPlanIDSeleccionado = Number.ToText(FiltroTestPlan),
Origen = OData.Feed("https://analytics.dev.azure.com/SomeOrganization/_odata/v3.0-preview/WorkItems?"
&"&$filter=WorkItemId eq "&testPlanIDSeleccionado
&"&$select=WorkItemId,WorkItemType,Title,State,Claro_ALM_TipoServicioPruebas,Claro_ALM_OrdenTrabajoId,Claro_ALM_TareaSolicitudPruebasId"&"&$expand=Claro_ALM_Asignado($select=UserName),Area($select=AreaName)", null, [Implementation="2.0"])
I get the following error
Formula.Firewall: Query references other queries, so it may not directly access a data source
Is there a way to solve this? Thanks in advance!
EDIT: Solved this by disabling data privacy levels on the file, as seen here https://blog.crossjoin.co.uk/2017/07/04/data-privacy-settings-in-power-bipower-query-part-4-disablin...
