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...
Loy
10 months agoFrequent Visitor
Hello,
Sorry for not answering sooner.
I won't upload any PBIX file as I'm not confident I'll be able to remove sensitive information or credentials. I have to protect myself and my company.
I trully think I've provided enough material for someone to test on their own environment. Just need to create a dummy table and stored procedure with two date parameters (begin and end) and corresponding columns returned, the other two parameters can be ignored since it works as expected.
If someone is willing to do that I'll be glad otherwise let's have a "virtual handshake", close the thread and part ways.
Cheers,
L