Connect to PowerBI Datamart to query SQL

Questions
1

Describe the problem/error/question

Want to connect to a PowerBI datamart to query it using the SQL Connector

What is the error message (if any)?

Failed to connect to XXX.datamart.fabric.microsoft.com:1948 in 15000ms

Information on your n8n setup

  • n8n version: 1.62.5
2

It looks like your topic is missing some important information. Could you provide the following if applicable.

  • n8n version:
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app):
  • Operating system:
3

Hey @Diogo_Elias,

Welcome to the community :tada:

Looking at the error I would assume that your database doesn’t allow connections from the outside world so you may need to add the IP of your n8n instance to your allow list.