Accessing Synapse (Private Endpoint) from Power BI Report via VNet Data Gateways

Question

Accessing Synapse (Private Endpoint) from Power BI Report via VNet Data Gateways

Rajaniesh Kaushikk 201 MVP

Hi,

I want to create a connection to Azure Synapse deployed with Private Endpoint from Power BI service. I have created VNet Gateway https://learn.microsoft.com/en-us/data-integration/vnet/create-data-gateways Now I am looking for instructions on How to access the Synapse database from the Power BI report. Any help will be greatly appreciated.

Regards

Rajaniesh

Anonymous

2023-10-06T12:15:56.1066667+00:00
@Anonymous

Thanks for approaching Microsoft Q&A

To To create a connection to Azure Synapse deployed with Private Endpoint from Power BI service, you need to follow these steps:

Enable private endpoints for Power BI in the Azure portal

Create a private endpoint for Power BI.

Open your Azure Synapse workspace in Azure portal and select Private endpoint connection under Security

Select Connect to an Azure resource in my directory in the Resource tab.

Select the Subscription that contains your Azure Synapse workspace.

The Resource type for creating private endpoints to an Azure Synapse workspace is Microsoft.Synapse/workspaces. Select your Azure Synapse workspace as the Resource.

Every Azure Synapse workspace has three Target sub-resource that you can create a private endpoint to: Sql, SqlOnDemand, and Dev.

When the deployment is complete, open your Azure Synapse workspace in Azure portal and select Private endpoint connections. The new private endpoint and private endpoint connection name associated with the private endpoint are shown.

After completing these steps, you can connect to your Azure Synapse workspace using private links

to access the Synapse database from the Power BI report, you can use VNet Data Gateways

You need to create a virtual network (VNet) data gateway and then create a SQL datasource pointing to the view.

for further queries please do let us know.
Rajaniesh Kaushikk 201 Reputation points MVP

2023-10-06T15:12:31.96+00:00

I already performed these steps but i need to know How to create report from it. I need step by step guidance on it
Rajaniesh Kaushikk 201 Reputation points MVP

2023-10-06T15:47:41.5733333+00:00

How do I create a connection to SQL datawarehouse?
Anonymous

2023-10-11T08:26:40.2866667+00:00
@Anonymous

To create a connection to SQL Data Warehouse, you can follow these steps:

Connect with SQL Server Management Studio (SSMS): You can use SSMS to connect to and query a dedicated SQL pool (formerly SQL DW) . To do this, you need an existing dedicated SQL pool, SSMS installed, and the fully qualified SQL server name. Open SSMS, select File > Connect Object Explorer, and fill in the fields in the Connect to Server window, including the server's name, authentication, username, and password. Once connected, you can explore your Azure SQL server and view the databases associated with it.

Create a dedicated SQL pool: You can create a dedicated SQL pool (formerly SQL DW) in Azure Synapse Analytics using the Azure portal In the portal, search for "dedicated SQL pool" and select it. Then, provide your subscription, resource group, dedicated SQL pool name, and server name. Once created, you can connect to the server using SSMS or other tools.

Use other tools: Other tools, such as Oracle SQL Developer or QuerySurge, can also be used to connect to SQL Data Warehouse. The specific steps for each tool may vary, but generally involve providing the necessary connection information, such as the server name, authentication, user name, and password.

Overall, the steps for creating a connection to SQL Data Warehouse involve providing the necessary connection information and using a tool that supports connecting to SQL Data Warehouse.

For further queries please do let us know.
Anonymous

2023-10-12T05:44:36.0433333+00:00

@Anonymous We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Anonymous

2023-10-13T11:05:17.4933333+00:00

@Anonymous just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Rajaniesh Kaushikk 201 Reputation points MVP

2023-10-17T22:10:31.6066667+00:00

I was able to resolve this
Anonymous

2023-10-24T09:48:53.15+00:00

@Anonymous did our solution helped you ?
George Dorovinis 0 Reputation points

2024-01-30T16:25:03.05+00:00

@Anonymous may ask you, for this case , do we need to create a power bi premium workspace also?

2 answers

Your answer

Anonymous

2023-10-06T12:15:56.1066667+00:00

@Anonymous

Thanks for approaching Microsoft Q&A

To To create a connection to Azure Synapse deployed with Private Endpoint from Power BI service, you need to follow these steps:

Enable private endpoints for Power BI in the Azure portal

Create a private endpoint for Power BI.

Open your Azure Synapse workspace in Azure portal and select Private endpoint connection under Security

Select Connect to an Azure resource in my directory in the Resource tab.

Select the Subscription that contains your Azure Synapse workspace.

The Resource type for creating private endpoints to an Azure Synapse workspace is Microsoft.Synapse/workspaces. Select your Azure Synapse workspace as the Resource.

Every Azure Synapse workspace has three Target sub-resource that you can create a private endpoint to: Sql, SqlOnDemand, and Dev.

When the deployment is complete, open your Azure Synapse workspace in Azure portal and select Private endpoint connections. The new private endpoint and private endpoint connection name associated with the private endpoint are shown.

After completing these steps, you can connect to your Azure Synapse workspace using private links

to access the Synapse database from the Power BI report, you can use VNet Data Gateways

You need to create a virtual network (VNet) data gateway and then create a SQL datasource pointing to the view.

for further queries please do let us know.
Rajaniesh Kaushikk 201 Reputation points MVP

2023-10-06T15:12:31.96+00:00

I already performed these steps but i need to know How to create report from it. I need step by step guidance on it
Rajaniesh Kaushikk 201 Reputation points MVP

2023-10-06T15:47:41.5733333+00:00

How do I create a connection to SQL datawarehouse?
Anonymous

2023-10-11T08:26:40.2866667+00:00

@Anonymous

To create a connection to SQL Data Warehouse, you can follow these steps:

Connect with SQL Server Management Studio (SSMS): You can use SSMS to connect to and query a dedicated SQL pool (formerly SQL DW) . To do this, you need an existing dedicated SQL pool, SSMS installed, and the fully qualified SQL server name. Open SSMS, select File > Connect Object Explorer, and fill in the fields in the Connect to Server window, including the server's name, authentication, username, and password. Once connected, you can explore your Azure SQL server and view the databases associated with it.

Create a dedicated SQL pool: You can create a dedicated SQL pool (formerly SQL DW) in Azure Synapse Analytics using the Azure portal In the portal, search for "dedicated SQL pool" and select it. Then, provide your subscription, resource group, dedicated SQL pool name, and server name. Once created, you can connect to the server using SSMS or other tools.

Use other tools: Other tools, such as Oracle SQL Developer or QuerySurge, can also be used to connect to SQL Data Warehouse. The specific steps for each tool may vary, but generally involve providing the necessary connection information, such as the server name, authentication, user name, and password.

Overall, the steps for creating a connection to SQL Data Warehouse involve providing the necessary connection information and using a tool that supports connecting to SQL Data Warehouse.

For further queries please do let us know.
Anonymous

2023-10-12T05:44:36.0433333+00:00

@Anonymous We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Anonymous

2023-10-13T11:05:17.4933333+00:00

@Anonymous just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others. Otherwise, will respond with more details and we will try to help.
Rajaniesh Kaushikk 201 Reputation points MVP

2023-10-17T22:10:31.6066667+00:00

I was able to resolve this
Anonymous

2023-10-24T09:48:53.15+00:00

@Anonymous did our solution helped you ?
George Dorovinis 0 Reputation points

2024-01-30T16:25:03.05+00:00

@Anonymous may ask you, for this case , do we need to create a power bi premium workspace also?

Answer 1

@Rajaniesh Kaushikk
Welcome to Microsoft Q&A platform and thanks for posting your question. I'm glad that you were able to resolve your issue and thank you for posting your solution so that others experiencing the same thing can easily reference this! Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others "I'll repost your solution in case you'd like to accept the answer.

Ask: I want to create a connection to Azure Synapse deployed with Private Endpoint from Power BI service. I have created VNet Gateway https://learn.microsoft.com/en-us/data-integration/vnet/create-data-gateways Now I am looking for instructions on How to access the Synapse database from the Power BI report. Any help will be greatly appreciated.

Solution: I was able to find the issue. I was using an differ Integration runtime. it is working now. If I missed anything please let me know and I'd be happy to add it to my answer, or feel free to comment below with any additional information. If you have any other questions, please let me know. Thank you again for your time and patience throughout this issue. ---Please don’t forget to Accept Answer and Yes for "was this answer helpful" wherever the information provided helps you, this can be beneficial to other community members.

Answer 2

Rajaniesh Kaushikk 201 MVP

I would suggest you to go over this video it will demystify many things. I learned from my mistakes and then created this video: https://www.youtube.com/watch?v=GXLXGNRqAZc

Anonymous

2024-01-31T07:18:46.3733333+00:00

@Rajaniesh KaushikkGlad to know your issue has been resolved. Since the Microsoft Q&A community has a policy that "The question author cannot accept their own answer. They can only accept answers by others "I'll repost your solution in case you'd like to accept the answer.

Share via

Accessing Synapse (Private Endpoint) from Power BI Report via VNet Data Gateways

2 answers

Your answer