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

Try your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now

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
Fabric Data Days is here Carousel

Fabric Data Days 2026

Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.

Power BI DataViz World Championships carousel

Power BI DataViz World Championships - June 2026

A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.