Hello,
I'm trying to build a custom connector for a data source that exposes an API with startDate, endDate parameters. I wrote the code for fetching all the data (my connector's type is (startDate as text, endDate as text) as table) and it works alright.
Now, I'd like to create a report where the user is able to choose the timeframe they are interested in such that the connector fetches data from the API using the (startDate, endDate) range. I am stuck here. Here is what I did:
- created 2 parameters of type date
- referenced the parameters via Transform Data > Advanced Editor in the query
Now, if I do Transform Data "arrow" > Edit parameters - I can change the start and end dates, and the data will refresh accordingly. That's great. I'd like to obtain the same via a slicer. Here is what I did next (trying to follow https://www.youtube.com/watch?v=zdVNkhTE21g😞
- created a new table with 2 date columns (startDate, endDate)
- selected one of them and went to Advanced, hoping to find "Bind to parameter" (like in the video) but I couldn't find that option
I did read that DirectQuery is required - and I added SupportsDirectQuery = true to my connector but that didn't change anything (I did choos DirectQuery mode when adding it).
So here I am. I'd imagine what I'm trying to achieve is straightforward, but it looks like I'm missing something. Any help here is appreciated. Thanks!
