Forum Discussion
Loy
1 year agoFrequent Visitor
Unable to bind a Date/Time column populated in DirectQuery mode with a Date/Time parameter
Hello, I'm working on a report that gets the data from a Table-Valued Function hosted on an Azure SQL server. That function has four parameters being "TeamList", "OwnerNameList", "AnalysisBeginDa...
lbendlin
Super User
1 year agoYes. Even the Capacity Metrics App report uses a DateTime M parameter. Check the limitations in the documentation.
Loy
1 year agoFrequent Visitor
Can you please be more specific?
lbendlin wrote:Yes. Even the Capacity Metrics App report uses a DateTime M parameter.
If you say so. I had a look but I'm unable to say whether a DateTime M parameter is used or not.
lbendlin wrote:Check the limitations in the documentation.
Limitations of the dynamic M parameters? Like said in the original post, I had a look but nothing told me what I'm trying to do is impossible or is done wrong.
Cheers,
L
- lbendlin1 year ago
Super User
TimePoints/TimePoint is a mandatory filter for the Capacity Metrics app, it is a DateTime field and is bound to the M parameter for the KQL query.