references other queries or steps, so it may not directly access a data source. Rebuild Data connect

[Red217]

Hello, 

i have a somewhat complex Query to work with Microsoft Graph

I have a WEB API query 

1.First i have an Outh2 Token process

2. then i reference to another query to get the "ID" list:

// List Settings
StepSelection = "Step 1",
Source = #"Sharepoint - show lists",
#"FilterByStep" = Table.SelectRows(Source, each Text.Contains([ListDisplayName], StepSelection)),
#"ListDisplayID" = Table.RemoveColumns(#"FilterByStep",{"ListDisplayName"}),
ListDisplayURL = #"ListDisplayID",
ListIDUrl = ListDisplayURL{0}[ListID],

3. then i call Microsoft Graph and i use the "RELATIVEPATH" so it will work on the POWERBI service

Response = Json.Document(Web.Contents(
//Response = Csv.Document(Web.Contents(
//"https://graph.microsoft.com",
"https://graph.microsoft.com",
[
RelativePath= "v1.0/sites/"&SiteId&"/lists/"&ListIDUrl&"/items?expand=fields",

Headers = [#"Authorization"=Bearer]
//Headers = [#"Content-Type"="application/json", #"Authorization"=Bearer]

SiteID is a Parameter andListIDUr is a value i got from another query

my problem is that "RelativePath= "v1.0/sites/"&SiteId&"/lists/"&ListIDUrl&"/items?expand=fields", has 2 parameters from 2 queries in it 😞 - so i am getting the annoying "references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.״

please help

[Anonymous · Accepted solution]

Hi @Red217 ,

This can have several problems behind, check the documentation below with information about possible errors and examples:

Dealing with errors - Power Query | Microsoft Docs

Behind the scenes of the Data Privacy Firewall - Power Query | Microsoft Docs

Solved: References other queries or steps, so it may not d... - Microsoft Power BI Community

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.