Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Shellysethi
Frequent Visitor

Importing data using API withing date range

Hello,

 

I have the api link 

https://companyservices.org/api/follow_BI/date_range_receive

and want to import data for 2 days in to power BI. How to do it 

4 REPLIES 4
Shellysethi
Frequent Visitor

@BA_Pete thank you.
The problem is solved. Thank you for your guidance.

Shellysethi
Frequent Visitor

Thank you @BA_Pete for reply.

the API link includes date range receive i.e this is my link
https://companyservices.org/api/follow_BI/date_range_receive
When I am following the steps suggested by you I am not getting any data but receiving 

Shellysethi_1-1688624727402.png

Am I doing anything wrong?

 

Yes, I was quite clear in my answer that you need to read the API documentation for your data provider to find the correct filter terminology to use. The URL I gave was purely an example of what it might look like and where to put the URL (Web Connector) to connect to the endpoint.

 

Again: You need to read the API documentation from the data provider to find the correct way to present the filters that you want to apply in the URL.

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




BA_Pete
Super User
Super User

Hi @Shellysethi ,

 

You'll first need to read the API documentation from the data provider to see the correct way to present the date filters in the URL to get what you want. Once you have that, put the URL, complete with correctly-presented filters, into the Web Connector.

 

It may look something like this but, again, you'll need to read up on the correct way to present the filter arguments for your particular endpoint:

BA_Pete_0-1688622445985.png

https://companyservices.org/api/follow_BI?date_start=20230705&date_end=20230707

 

 

Pete



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.