Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
Hello,
I am looking to have a script written in power query in Power BI which reads an excel sheet, makes a call to an API and populates the table. Is this possible to achieve? Help would be appreciated.
Thank you
Hi @Junaid11
What do you read from an Excel sheet? To get data from Excel, you can use Excel Workbook connector. To get data from an API, you can use Web connector. You can also write M codes to provide more custom information to Web.Contents() function to call an API.
If you store variables (to be used in API) in a column in Excel, you can first connect to this Excel file to get data. Then add a column by invoking a custom function to call an API. This new column will have all data returned by API. Expand it to see all data in the table.
Here are some tutorial videos for your reference.
Use Power BI to loop through multiple pages of an API - YouTube
Scrape Data from Multiple Web Pages with Power Query - YouTube
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Yes
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
Hello @KNP ,
May I know any source from where I can see that practically been done. It woukd be quite useful.
Thank you
Hi @Junaid11,
Would you be able to provide more detail about your specific issue so I can better answer your question?
This post may be useful in helping you structure a question to better get the support you need.
Have I solved your problem? Please click Accept as Solution so I don't keep coming back to this post, oh yeah, others may find it useful also ;). |
Hello @KNP ,
May I know any source from where I can see that practically been done. It woukd be quite useful.
Thank you