Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I'm getting the following error when refreshing my query:
Falha na última atualização: Tue May 09 2017 09:58:54 GMT-0300 (E. South America Standard Time)
Erro durante o processamento de dados no conjunto de dados.
Tipo de fonte de dados: | |
Erro de processamento: | [Unable to combine data] Section1/Query1/AutoRemovedColumns1 is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination. |
Cluster URI: | WABI-SOUTH-CENTRAL-US-redirect.analysis.windows.net |
ID da atividade: | 3941fa6a-ebf8-4ba3-b044-cd5a7e755adf |
Solicitar ID: | ff48cd7e-f884-e868-8428-c1966b2f3d0a |
Hora: | 2017-05-09 12:58:54Z |
I'm consulting two VSTS REST APIs:
- The first one executes a VSTS Workitem Query and returns a json file with the ids of workitems that satisfy the query;
- The second, I execute to get all the data for each id of workitem retrieved from the first api call;
I used a similar procedure as described here:
https://blogs.endjin.com/2016/07/querying-the-vsts-work-items-api-directly-from-power-bi/
All works fine in Power BI Desktop, the error is only in PowerBI.com.
The privacy option is "None" for all datasources, and I'm using Basic Authentication with a VSTS PAT (Personal Access Token).
I think my issue is equal to this one:
https://community.powerbi.com/t5/Service/Refresh-error-when-combining-multiple-Web-queries/m-p/67897
This is the sample code of my model, I built some functions to let it more reusable:
https://gist.github.com/igorguga/40cbf934077bf76b0ba29656ec407d95
But I get the error even when I try a simple sample like this https://charlesneedhamcn.wordpress.com/vsts-as-a-powerbi-datasource/.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.