Hello all, we have been asked about ways to automatically import all data from a Tulip Table into Power BI. This guide will show you how to accomplish this for records of a table leveraging the Tulip Table API and Python. This article assumes basic knowledge about HTTP requests and Python coding. …

Faster way it to use Web connection and Power query to make connection between power bi and tulip table. No code and easier Why make it simple when you can make it complicated :wink:

@mathieu.rey thanks for your comment! You are right. The Web connection enables to query the API as well and connect to Tulip Tables easily. Though, to my knowledge, in a limited way. As our “records” endpoint has a return limit of 100 records, this will not directly allow you to grab all the data …

I let you watch that previous post [image] getallTulipTableRecords in Excel Show and tell 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 be…

Thanks for the quick update. This will be very helpful for others who are looking to use the Power Query way! It’s always good to have multiple approaches to choose from.

One thing to note here is that if end user needs this report in PBI service they are restricted to personal gateway, I believe as of right now the “Enterprise/Regular Gateway” service does not support python script as a data source. Python/R Visualization are supported regardless of gateway type.

Has anyone found a way of doing something similar in Tableau? Looks like you can use python there as well. [image] Use Python scripts in your flow Disclaimer: This topic includes information about a third-party product

Hello Stefan, I tested to get data from a tulip table using this python code and I encountered “NameError: name ‘headers’ is not defined”. I needed to delete “headers=headers,” around line 50. Kindly fix the original code for community members. Thanks. Akira

Hello Akira, thanks for your feedback! I seem to have missed this bit when I last updated the code - sorry for that. I have corrected the code. Best, Stefan

good afternoon @curtis.hale , welcome to the Tulip community!! it would be great if you could introduce yourself at: Welcome to the Community, let's meet! ! regarding the error your seeing, would you mind emailing support@tulip.co ?? they’ll be able to help resolve this issue.

So I tried to follow this guide, but it didn’t work. I’m totally new to python. Got some HTTPErrors etc. Need to debug what’s wrong so just tried a simple get request to see if that works in a first place, but I get Forbidden 403 response. What am I doing wrong? [image]

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

General

mathieu.rey November 17, 2020, 11:18pm 4

I let you watch that previous post

Topic		Replies	Views
getallTulipTableRecords in Excel Show and Tell	13	1680	November 18, 2021
Instructions on how python and Tulip work together General	1	1193	April 13, 2021
Export Table to Power Automate General	5	616	February 22, 2024
Send Data from Python and Tulip Support, Troubleshooting, & Help	5	1031	December 22, 2022
Add an API route to download all table records as a CSV file Product Suggestions api , power-bi , table-api	0	42	April 17, 2026

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

Related topics