Forum Discussion
Using Parameter to define if a table is loaded or not
Microsoft EmployeeYour approach seems good, and I would have guessed it would work. Since it doesn't, one other thing you can try is to use your True/False parameters to change the output of Load_Archive queries. You could put an if in the last step of each. If false, have it return null or a really small dummy dataset you then filter out. The evaluation should skip loading the archive dataflows if the condition is not met (False). So that way, if it won't avoid processing your archive queries, it will have much less work to do first (and not use the dataflow).
If this works for you, please mark it as the solution. Kudos are appreciated too. Please let me know if not.
Regards,
Pat
mahoneypat Good idea but really its the same solution as you said.
I got it to work though!!!
I was referancing other queries that landed the DataFlows into the model first what I did is moved this landing queries into the code to be inside the condition check in the code I shared above and this now works as intended.
Cheers...