Forum Discussion
Post PatronQuery references other queries or steps, so it may not directly ac
Hi Digger ,
Please review the following links which has the same problem as yours, hope the solution also can help you solve the problem.
Power BI: Query references other queries or steps, so it may not directly access a data source.
Go to File>Options/Setting>Options
1. Uncheck Require user approval for new native database queries under Native Database Queries in Security options.
2. Ignore Privacy level setting under privacy options
Behind the scenes of the Data Privacy Firewall
Power Query Errors: Please Rebuild This Data Combination
Query references other queries or steps, so it may not directly access a data
If the above ones can't help you solve the problem, please provide the applied codes of the query which get the error. If this query reference any other query, please also provide the related applied codes. Thank you.
Best Regards
This did not work for me. I am still having this error message despite having even separated things into 2 distinct queries (and Privacy Level checks are OFF). Any thoughts?
//Query Called Solution
let
Source = Excel.Workbook(Web.Contents("https://SHAREPOINT ADDRESS/Sample%20UPS%20Data.xlsx"), null, true),
Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data]
in
Sheet1_Sheet
//Second query referencing the first query called Solution
let
Source = Solution,
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Added Custom" = Table.AddColumn(#"Promoted Headers", "Custom", each let
Local_Access_Token = ACCESS_TOKEN,
response = Web.Contents(#"UPS API Site", [
RelativePath = "api/track/v1/details/" & [Ups Tracking Number] & "?locale=en_US&returnSignature=false&returnMilestones=false&returnPOD=false",
Headers=[Authorization="Bearer " & Local_Access_Token, transId="1", transactionsrc="PowerBI UPS Tracker"]]),
jsonResponse = Json.Document(response)
in
jsonResponse)
in
#"Added Custom"