Using Sesame Data with PowerBi
This tutorial shows how to use Power Query to use the Paged Holdings endpoint.
Open PowerBi desktop
Click on
Get data
and selectWeb
Select
Basic
, paste the URL, clickOK
You will find more information about the URL HoldingsWhen the authorization window pops up, select
Basic
, type in yourUsername
andPassword
(read more)It will arrive at a screen similar as below:
Then it is needed to delete all
Applied Steps
and only keepSource
:Right Click on
totalPages
and selectAdd as a new query
:Once the new query is created, click on
Advanced Editor
at the top:Then change the code to produce a list of pages:
Click on
To Table
at the top left:
When pop up window appears, click
OK
:Select the original table and click on
List
:Then click on
To Table
and clickOK
:Click on
Expand Columns
icon and clickOK
:Click on
Advanced Editor
and add the following code at the beginning:(page as text) =>
As well as changing the page to be a parameter:
Rename the function to
getPage
to be more clearChange the column type to
Text
:Select the other table
totalPages (2)
then click onInvoke Custom Function
:Select the function we created previously and click
OK
:Click
Expand Columns
and clickOK
:Finally, click
Close & Apply
:
Last updated