Tech Labs | 14 Jun 2022

API Databank – Saved selection to PowerBI

Technology Team

Oxford Economics

  1. Open Swagger by accessing following path – https://services.oxfordeconomics.com/Swagger

2. Click on /Users directory. In the dropdown, click on GET /api/users/{id} option. Next to id parameter, in the value column, type “me”. Once done, click on Try it out! button.

3. The new sections will appear. In the Response Body section, find “SavedSelection” part, which contain the information on every saved selection in databank under your account. Copy id of a saved selection you wish to access.

4. In PowerBI new project, click on button Get data and chose the Web option.

5. If Web option is not available please select More… option, a new window will pop-up, please select Web option under Other tab.

6. Select Advanced tab

7. If you are connecting to API from Power BI for the first time, following window will pop-up. Please proceed by clicking Connect, so we can set up anonymous access.

8. Finally, PowerQuery editor should open up with the established connection to saved selection table

9. Click File => Close & Apply

10. The saved data should now be available under the Data tab

Related Services

Post

From opportunity to impact – Assessing the economic, societal, and cultural benefits of YouTube in Finland

This study assesses YouTube's contribution to GDP and employment in Finland, and its broader impact on society and culture.

Find Out More

Post

Mahdollisuuksista vaikuttavuuteen – Arviointi YouTuben taloudellisista, yhteiskunnallisista ja kulttuurisista hyödyistä Suomessa

Tässä tutkimuksessa arvioidaan YouTuben vaikutusta Suomen bruttokansantuotteeseen ja työllisyyteen sekä sen laajempaa vaikutusta yhteiskuntaan ja kulttuuriin.

Find Out More

Post

Economic Impacts of The Umbrella Academy Season Two in Ontario

In 2019, production of Season Two of “The Umbrella Academy” resulted in total spending in Ontario of over C$77.3 million.

Find Out More