Forum Discussion

Sanjota05's avatar
Sanjota05
Frequent Visitor
5 months ago
Solved

Dynamic M query parameter binding to a query table which uses import mode

At the moment I am using a dynamic M queries within a SQL queries which is in import mode. I have 9 custom sql queries where the data is being filtered in these queries by adding parameters in where ...
Need Help
Show and Tell
Tips and Tricks
  • Natarajan_M's avatar
    Natarajan_M
    5 months ago

    Hi Sanjota07 ,


    Non-null assertion failure: resource: Resource should be available for query Query2 to store FoldedArtifacts in cache This corresponds to that the pbi engine cant fold the entire query in direct query mode so this flag is raised 

    You can also try this approach :
    let
    Source = Sql.Database("",""),
    PrCase = Source{[Schema = "dbo", Item = "Table"]}[Data],
    FilteredRows = Table.SelectRows(PrCase, each [Active] = #"Active")
    in
    FilteredRows

    Thanks

  • Sanjota05's avatar
    Sanjota05
    Frequent Visitor
    5 months ago

    Hello Natarajan_M 

     

    I have loaded the table in blank PBIX file and this time I just used only one parameter 

     

    Sqltext="Select * from orders where orderID =@porderID

     

    Still import mode was choosen. Not sure what is the issue.

     

    Thank you so much for your valuable assistance Natarajan_M