Forum Discussion
Formula.Firewall: Query references other queries or steps
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 ?
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
SearchIssue
I 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!- ayup8 years agoHelper I
Hi Mozasf
Can you confirm if you managed to solve the issue re refreshing JIRA data via the Power BI service?
I have an identical situation using JIRA data - i.e. loads OK via PBI Desktop but not PBI Service - and am struggling to find a solution.
Any help appreciated.
Thanks