Forum Discussion
Formula.Firewall: Query references other queries or steps
Hi everyone!
I'm having similar error as you Issue #1.
[Unable to combine data] Section1/Consulta1/AutoRemovedColumns1 is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination.
In my case I'm trying to conect to JIRA:
Query1 -> Connects to JIRA to get a list of issues.
Query2 -> Take the list generated in Query1 and connects to JIRA to look for info of every issue.
I've tried the link way above, I change the Privacy and gives me the same error.
Any other way?
Thanks!
HI,
In your queries , are you using "Merge Queries as New" by any chance ?
Is it possible to rebuild the data model by using relationships instead of creating a new query ?
- Anonymous9 years agoNot applicable
Hi Anonymous!
No, I'm not using any kind of Merge.
I think that It's not possible ussing relations. It´s needed a JSON query for every issue to bring the info.I'm modifying the JIRA content pack in which, first of all uses a instruction like this to bring the list of issues:
let FetchPage = (url as text, pageSize as number, skipRows as number) as table => let contents = Web.Contents(URL,[RelativePath = "rest/api/2/search",Query = [maxResults= Text.From(pageSize), startAt = Text.From(skipRows)]]), json = Json.Document(contents), Value = json[issues], table = Table.FromList(Value, Splitter.SplitByNothing(), null, null, ExtraValues.Error) in table meta [skipRows = skipRows + pageSize, total = 500] in FetchPageOnce I have the list of all id issues, I need to do a query for every issue. Something like this:
let SearchIssue = () => let Source = FetchPages("", 500), table = Table.ExpandRecordColumn(Source, "Column1", {"id"}, {"id"}), Search = (id) => let Issue = Json.Document(Web.Contents(URL,[RelativePath="rest/api/2/issue/"&id])) in Issue, Output = Table.AddColumn(table, "incidencia",each Search([id])) in Output in SearchIssueI don't find the solution.
- Anonymous9 years agoNot applicable
HI,
I believe you are facing this issue with Power BI Desktop. Can you please try by un-check the "Parellel loading of Tables" and re run the refresh, hope it might avoid this issue.
Regards,
Sivapratap.
- Anonymous9 years agoNot applicable
Hi Anonymous,
I have un-checked the "Parellel loading of Tables" and the online refresh gives me the same error:
[Unable to combine data] Section1/Datos/AutoRemovedColumns1 is accessing data sources that have privacy levels which cannot be used together. Please rebuild this data combination.
The refresh works on my desktop but online It doesn't work.
Thanks for the answer!