cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sbahugu2
Helper I
Helper I

filter data source using visual selection change

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 ?

3 REPLIES 3
v-jiascu-msft
Microsoft
Microsoft

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!