Share via

Connecting to Synapse Serverless pool from power BI

Shatamjeev Dewan 1 Reputation point
2021-06-10T19:14:59.793+00:00

Hi,

Can we connect Azure Synapse serverless pool tables/view from power bi desktop ?

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Samara Soucy - MSFT 5,141 Reputation points
    2021-06-13T19:02:21.987+00:00

    Generally yes, though you may need to update the firewalls on the public endpoint to allow access.

    The connection string is available from the portal, and follows the pattern <workspace name>-ondemand.sql.azuresynapse.net

    105117-serverless-link.png

    If you need to update the firewall, this is also readily available in the portal.

    105059-ip-firewall-3.png

    0 comments
  2. PRADEEPCHEEKATLA 91,656 Reputation points Moderator
    2021-06-15T11:02:53.63+00:00

    Hello @Shatamjeev Dewan ,

    In additional to @Samara Soucy - MSFT response.

    Get the Serverless SQL pool service endpoint address from Azure Portal.

    105797-image.png

    Here is the walkthrough on connecting Power BI desktop to serverless SQL pool.

    105796-synapsesqlserverlesspbidesktop.gif

    For more details, refer Connect to serverless SQL pool with Power BI Professional.

    Hope this helps. Do let us know if you any further queries.

    ------------

    • Please accept an answer if correct. Original posters help the community find answers faster by identifying the correct answer. Here is how.
    • Want a reminder to come back and check responses? Here is how to subscribe to a notification.
    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.