Forum Discussion
[Unable to combine data] Section1/asd/TransformToList references other queries or steps
[Unable to combine data] Section1/Products/TransformToString references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
In Power BI Desktop updating finish successfully, But in Power BI Service with error
In Power Query exists:
Query 1. "Vendors" for Parameter
let
QueryString = " CALL GetVendorsList(); ",
Data = MySQL.Database("IP", "DB", [ReturnSingleDatabase=true, Query = QueryString]),
Vendors = Data[Vendors]
in
Vendors
Query 2. Parameter "VendorParameter", that is using List from Query 1
"Apple" meta [IsParameterQuery=true, ExpressionIdentifier=Vendors, Type="Any", IsParameterQueryRequired=true]
Query 3. "Products" string, separated with comma
let
QueryString = " CALL GetVendorProducts('" & VendorParameter & "'); ",
Data = MySQL.Database("IP", "DB", [ReturnSingleDatabase=true, Query = QueryString]),
TransformToString = Text.Combine( Table.ToList(Data, Combiner.CombineTextByDelimiter(",")), ",")
in
TransformToString
In Query 3 we get result like 'iphone6,iphone7,ipad2'
Query 4. "Indicators" that is using Query 3 result
let
QueryString = " CALL GetIndicators('" & Products &"'); ",
Data = MySQL.Database("IP", "DB", [ReturnSingleDatabase=true, Query = QueryString]),
ChangedType = Table.TransformColumnTypes(Data,{
{"PortID", type text},
{"ScanDate", type date}
})
in
ChangedType
In Power BI Desktop Parameters is set Privacy -> Always ignore Privacy Level settings
In Connection Privacy - None
Please, help to solve this issue
2 Replies
- AnonymousNot applicable
Hi googlogmobi ,
What kind of error are you getting?
Best Regards,
KellyDid I answer your question? Mark my post as a solution!- googlogmobiFrequent Visitor
Hi, Anonymous
[Unable to combine data] Section1/Products/TransformToString references other queries or steps, so it may not directly access a data source. Please rebuild this data combination.
And data update througth Power BI Gateway fails