Automate lots of API download

Resolved · Low Priority · Version 365

Wed 11 May 2022, 17:39 Delegate 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:55 Trainer 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.

Training courses

	98.7 % recommend us
	More live stats...

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Power BI tip:

Data Model Shortcuts

Ctrl + Shift + L: Create a relationship between tables.
Ctrl + K: Create a new calculated column.
Ctrl + Shift + N: Create a new table.
Ctrl + Shift + K: Create a new measure.
Ctrl + D: Duplicate selected table or measure.

View all Power BI hints and tips