filter data source using visual selection change

[sbahugu2]

Hi All,

          I have a power BI report which fetches data from an API. API has a date range and for each day data is added to data source from which API is returning data.

I dont want to load all the data in Power BI and then apply slicer or filter. Is there any way I can call the API at run time with user selected date range and loads only data which is required ?

[v-jiascu-msft]

Hi @sbahugu2,

I'm afraid it's hard to select the range in a slicer or a filter. But the parameter could be helpful. Please refer to this post. When we change the value of the parameter, new data will be fetched.

Best Regards,

Dale

[sbahugu2]

Hello thanks for the reply.

Using parameters have few limitation in my case:

1) parameters are limited to PBI desktop only and so not work with service or published report.

2) Every time there is change required in parameter values we need to publish the report again with refreshed data set and so its not good idea

[v-jiascu-msft]

Hi @sbahugu2,

I'm afraid there isn't a better way for now. I would suggest you vote up this idea or create a new one.

Best Regards,

Dale