Pre-requisites
Pre-requisites: You must have a running Streambased server before following this guide. For details on how to run Streambased see the documentation here: https://streambased-io.github.io/streambased/index.html or run one of the demos here: https://github.com/streambased-io/streambased-demos
Step 1: Download and install the Streambased ODBC Driver
ODBC integration is provided by the Simba Trino ODBC Driver here: https://insightsoftware.com/drivers/trino-odbc-jdbc/
Download, install and licence this driver as is appropriate for your deployment.
Step 2: Create a new data source
Now start PowerBI and, under “Get Data”, select “More…”
![](https://cdn.prod.website-files.com/66098d655e9084457b00d675/6662fb9e136904049bfee1f3_Picture1-6-882x1024.png)
In the popout search and select “ODBC”
![](https://cdn.prod.website-files.com/66098d655e9084457b00d675/6662fb9ef8e5139a7e2ea5b4_Picture2-3-1024x622.png)
Step 3: Configure the connection
Next configure the data source, connection details and query are supplied together:
![](https://cdn.prod.website-files.com/66098d655e9084457b00d675/6662fb9ef1d2298747a2bc04_Picture3-3-1024x786.png)
The connection details are provided in a single string in form “Host={streambased server host};Port={streambased server port}
Step 4: Update the query result
Now you can preview and load the data source into PowerBI.
![](https://cdn.prod.website-files.com/66098d655e9084457b00d675/6662fb9e5a505a31689625aa_Picture4-2-1024x779.png)