How to connect to Power BI Datamart

Is there a way to connect directly to MS Power BI’s new Datamart using the SQL endpoint?

Have you checked the MS Docs yet?
There might be an enpoint url
sth. like
randomstring.datamart.pbidedicated.windows.net
br

Hi Daniel, yes have checked MS Docs and it appears that the endpoint url created when setting up the datamart should work in the same way as a stand alone SQL server.

When trying to run the Microsoft SQL Server Connector node with the Hostname as randomstring.datamart.pbidedicated.windows.net, the below error message appears:

Execute failed: The TCP/IP connection to the host randomstring.pbidedicated.windows.net\6X3W4SXZHDPU5BLSEKEJYXMDSI-UJIUIHKNQ6CUDGBVDMPXIBTCJE, port 1433 has failed. Error: “null. Verify the connection properties. Make sure that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port. Make sure that TCP connections to the port are not blocked by a firewall.”

Dropping the firewall has no impact.