Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Query references other queries or steps, so it may not directly access a data source. - refresh fail

Hi All,

 

Could you please help me with an annoying error I am facing while trying to refresh the report in the Power BI service environment?

The query is refreshing properly on the Desktop however, I am getting the below error in the Power BI service.

 

Data source error[Unable to combine data] Section1/Users/Changed Type references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.

 

 

I have changed the privacy level to the Organizational level in both the Desktop and Service but the error still persists.

 

 Below is the power query I am using:

 

 

let
    users = Devices[Index],
    deviceID = Devices[deviceID],
    source = List.Generate(
    ()=> [val=0, Result=#"Users Function"(deviceID{val}), device_ID=deviceID{val}],
    each [val] < List.Count(users), each [Result=#"Users Function"(deviceID{val}), val=[val]+1], each [Result]),
    #"Converted to Table" = Table.FromList(source, Splitter.SplitByNothing(), null, null, ExtraValues.Error),
    #"Added Index" = Table.AddIndexColumn(#"Converted to Table", "Index", 0, 1, Int64.Type),
    #"Reordered Columns" = Table.ReorderColumns(#"Added Index",{"Index", "Column1"}),
    #"Expanded Column1" = Table.ExpandRecordColumn(#"Reordered Columns", "Column1", {"value"}, {"Column1.value"}),
    #"Expanded Column1.value" = Table.ExpandListColumn(#"Expanded Column1", "Column1.value"),
    #"Expanded Column1.value1" = Table.ExpandRecordColumn(#"Expanded Column1.value", "Column1.value", {"id", "accountName", "accountDomain", "accountSid", "firstSeen", "lastSeen", "mostPrevalentMachineId", "leastPrevalentMachineId", "logonTypes", "logOnMachinesCount", "isDomainAdmin", "isOnlyNetworkUser"}, {"Column1.value.id", "Column1.value.accountName", "Column1.value.accountDomain", "Column1.value.accountSid", "Column1.value.firstSeen", "Column1.value.lastSeen", "Column1.value.mostPrevalentMachineId", "Column1.value.leastPrevalentMachineId", "Column1.value.logonTypes", "Column1.value.logOnMachinesCount", "Column1.value.isDomainAdmin", "Column1.value.isOnlyNetworkUser"}),
    #"Renamed Columns" = Table.RenameColumns(#"Expanded Column1.value1",{{"Column1.value.id", "id"}, {"Column1.value.accountName", "accountName"}, {"Column1.value.accountDomain", "accountDomain"}, {"Column1.value.accountSid", "accountSid"}, {"Column1.value.firstSeen", "firstSeen"}, {"Column1.value.lastSeen", "lastSeen"}, {"Column1.value.mostPrevalentMachineId", "mostPrevalentMachineId"}, {"Column1.value.leastPrevalentMachineId", "leastPrevalentMachineId"}, {"Column1.value.logonTypes", "logonTypes"}, {"Column1.value.logOnMachinesCount", "logOnMachinesCount"}, {"Column1.value.isDomainAdmin", "isDomainAdmin"}, {"Column1.value.isOnlyNetworkUser", "isOnlyNetworkUser"}}),
    #"Changed Type" = Table.TransformColumnTypes(#"Renamed Columns",{{"firstSeen", type datetime}, {"lastSeen", type datetime}})
in
    #"Changed Type"

 

 

Could anyone please share some insights to get rid of this annoying error.

 

Thank you

Need Help
No Replies