Forum Discussion

googlogmobi's avatar
googlogmobi
Frequent Visitor
6 years ago

[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

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi  googlogmobi ,

     

    What kind of error are you getting?

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!
    • googlogmobi's avatar
      googlogmobi
      Frequent 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