Forum Discussion
how to pull data from post api data to power bi
Hi Team,
Can any one guide me how can i pull data from post API link to power bi.
Actually i have Post API url it's belongs to employee check in and check out details and i have ID and KEY and body method in body method when i pass employee ID and Date then only it is showing details in postman with the same process i need to fetch it in power bi how can i fetch.
pls let me provide M query to fetch details.
6 Replies
What have you tried and where are you stuck?
https://learn.microsoft.com/en-us/powerquery-m/web-contents has good documentation on how to do this.
Hi lbendlin,
Thankyou for reply, Actually i have sample API link to fetch attenence details and i don't have any Employee Name details and their EmployeeID details. But i have URL link and Body details in body details i need to submitt date details and employee id then it show's employee details as his checkin and checkout time details and description status details. when i tried to fetch details same process in power bi i can fetch only one record at submitted date period i want to fetch all the details when user want to see either weekly, monthly, yearly and days wise. how to call all employee details by passing employee id and with certain date range details about his attendence details.
Your POST API should have documentation on how to structure the payload for such a query. Can you share the documentation link?
Hello lbendlin ,
Yes, you can check below documentation link which i have provide to you. what i need is when you click on documentation link you can see Attendance API link. with that link how can i fetch all the employee details for entire month date range. it is showing only for perticular date only.
https://documenter.getpostman.com/view/11662503/Tzm5HckE#99c4630c-ff72-4f66-a986-30f00d555cf7Actually iam fetching single employee details with single record that to when iam providing employee id and date it's is fetching that particular record details. actually i need to fetch that particular employee details for entire monthly base and how can i loop it for all the employees details without entering it manually about employee id and date.
According to the documentation you may have to do separate API calls. For the attendance call try to omit the employee ID and the date, and see if there are any results.
