98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Power BI training and help » Automate lots of API download
Automate lots of API download
Resolved · Low Priority · Version 365
Wed 11 May 2022, 17:39Delegate Athena said...
Athena has attended:
Power BI Modelling, Visualisation and Publishing course
Automate lots of API download
Hi Jens,
I hope you are well and I could do with some advice.
We have a data souce which split API data into a number of website (we are talking about 25+ dataset split into different website). The data structure are similar inside the website. I can manually doing one by one. However, I am wondering if there are a way of systematically (1) download and (2) mulnipulate data?
Out of curiosity, is there a way of using VBA to work inside PowerBI (mulnipulate data and create charts)?
thank you
Thu 12 May 2022, 09:55Trainer Jens said...
RE: Automate lots of API download
Hi Athena,
Thank you for the forum question.
You can live connect to the data in tables on websites. You will then get the 25+ tables in Power BI. If the tables are structured exactly the same way, you can use the append tool in the query editor to append all the data into one table, and the manipulate the appended data.
If the data are not structured exactly the same way (for Power BI to be able to pair up the columns correct the headings across all the tables must be the same).
You may need to manipulate the tables before you append all the data.
If you connect live to all the data and append and do the manipulation, your reports will just update when the data change in the tables, you have connected to.
No you cannot use VBA in Power BI. You can use Power Query M, DAX, R Script, SQL, and Python in Power BI.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
Thu 19 May 2022: Automatically marked as resolved.
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Power BI tip:Data Model ShortcutsCtrl + Shift + L: Create a relationship between tables. |
