Forum Discussion
Aged Debtors Report - Passing In Date and Client ID Parameters
Microsoft EmployeeHi sonnydeletejc,
The scenario here couldn't be the common practice in the Power BI. Usually, we connect to SQL db and fetch data once. And then manipulate data in the Power BI. Even in the Direct Query mode, we still do what we want in the Power BI and Power BI will send the queries to SQL db.
What do you want to achieve with this query? Maybe the approach is different in Power BI.
Best Regards,
Dale
Hi v-jiascu-msft,
Thanks for your reply. The purpose of the query is to look at client debts by age (1-30, 31-60 days etc), excluding debts which had been paid at the 'As Of' date, as well as debts which didn't exist yet exist on the 'As Of' date (created after that date).
So running with, say, an 'As Of' date of 1st October 2017... ignore any debts which had been paid prior to that date, as well as any new debt created beyond that date.
I could use less than and greater than filters to do this, but my aim is to filter prior to running the query, rather than pulling everything back and then filtering. Trying to be as efficient as possible. As you say, I guess this isn't the way PBI works.
J