Forum Discussion
Formula.Firewall: Query references other queries or steps
Anonymous,
Thanks for your reply. This is very useful information.
Amy Jo
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!
- Anonymous9 years agoNot applicable
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.