Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.