Guide: Using the Table API and Python to import data from a Tulip Table into Power BI

[mathieu.rey]

I let you watch that previous post

getallTulipTableRecords in Excel

Hi, you can get all records from tulip table thanks to BOT. For this you need to use powerQuery functionnality on Excel. You can easily copy the function in advanced editor (see below) (TulipTableId as text) as table=> let Query = #table( type table [#“TulipTableId” = text], { {TulipTableId}}), Function = Table.AddColumn(Query, “Offset”, Number.Round(Json.Document(Web.Contents(“https://[server]/api/v3/tables/”& TulipTableId &"/count"))/100)), ExpandedOffset =Table.ExpandListCol…