Forum Discussion
Dynamic M query parameter binding to a query table which uses import mode
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
Hi Sanjota05
In import mode, changing a parameter requires refreshing the model (which means refreshing the underlying data).
I have a question: If we can import the data into the model, can we then use slicers to display the relevant data?
For example, if a user needs to view the products associated with Order ID 1234, can we simply set up a slicer based on the Order ID to display that specific data? Please let me know if I am misunderstanding anything here.
What is the core problem statement you are trying to solve?
Thanks
Hello Natarajan_M ,
You mean after loading the data in import mode instead of using parameter , I can use the associated orderID column directly in slicer and limit data ?
If my understanding of your question is correct, yes we can do that but in my case the data should be filtered from the query it self, not from the visual side. The data should filtered before loading
Because the data size is huge 40 lakhs of data is there so we are trying to limit the data before loading and users needs to have option load the data by different filtering values dynamically.
Problem statement:
I have already created Parameter and used in it custom sql in M query to limit data before loading. So now I need to make this parameters dynamic so that users can select any values and load the data from power query.
As my tables are import mode I cannot to create dynamic parameters using bind to parameter option which is available only in direct query.
Thank you!