PowerBI- connect to Dremio

1

Hello, I’m new to this so I am not sure wich link i have to put here in my PowerBi to connect to dremio.
What i am trying to do is connecting elasticsearch to dremio and dremio to PowerBi. I tried to put the localhost of my dremio but it didn’t connect…

image
image.png693×249 4.72 KB

2

Per our documentation

Enter the IP address for one of the coordinator nodes in your Dremio cluster and select the DirectQuery option.

For example - if your URL to access Dremio UI is http://192.168.1.1:9047, then in PBI you would enter 192.168.1.1 for the Dremio Cluster Node

3

This is what i filled in.

image
image.png734×318 5.1 KB

image

But i get this error:
image

this is my dremio connector:

image
image.png473×617 13.2 KB

4

For PowerBI, the port to use is 31010 (as shown in your own capture of the Dremio Connector DSN Setup), which is different from the 9047 port you put (which is only used to access the Web UI). But you can simply use localhost (no port), and PowerBI should let you connect.

1 Like