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.
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
Hi @SDicksonDulux,
Did you use randomstring.pbidedicated.windows.net verbatim in your connection? Because the “randomstring” part must be replaced by your personal endpoint for your datamart. A description how to find it is documented here: Analyzing datamarts (preview) - Power BI | Microsoft Learn.
Kind regards,
Alexander
2 Likes