How to connect Azure Synapse spark pool with Power BI ?

Question

How to connect Azure Synapse spark pool with Power BI ?

Nontaphat Saksathianpong 21

I create some delta tables (delta lake) in Azure Synapse spark pool.
Is it possible to connect these tables with Power BI ?

HimanshuSinha-msft 19,481 Reputation points Microsoft Employee

2020-08-25T19:35:36.983+00:00

Hello @NontaphatSaksathianpong-4546,

Thanks for using the forum .
Please do let me reach out to the internal team to get some help on this ask . I will update you once I hear from the them .

Thanks
Himanshu

Accepted answer

1 additional answer

Your answer

HimanshuSinha-msft 19,481 Reputation points Microsoft Employee

2020-08-25T19:35:36.983+00:00

Hello @NontaphatSaksathianpong-4546,

Thanks for using the forum .
Please do let me reach out to the internal team to get some help on this ask . I will update you once I hear from the them .

Thanks
Himanshu

Answer 1

HimanshuSinha-msft 19,481 Microsoft Employee

Hello ,

Just heared back from the internal team as of today PBI does not connect to Synapse Spark .

Request you to please to log the feature request @ : https://feedback.azure.com/forums/307516-azure-synapse-analytics . The product group can review the ask they can act on the same . Once you have added the feedback please let us know .

Thanks Himanshu
Please do consider to click on "Accept Answer" and "Up-vote" on the post that helps you, as it can be beneficial to other community members

Fred Catameo 6 Reputation points

2021-10-07T06:44:41.667+00:00

Hello Himanshu,

Any new developments on this one? Can PowerBI Desktop now connect to Azure Synapse Spark (specifically to query a Synapse Spark Delta table)?
Also can a .NET C# application connect to Azure Synapse Spark to query a Synapse Spark Delta table?
We've tried the Synapse Serverless / On-demand connection and it works but just wanted to check for Synapse Spark pool.

Thanks

Answer 2

Ronen Ariely 15,201

Hi :-)

Check of the Microsoft tutorial helps you:

https://learn.microsoft.com/en-us/azure/synapse-analytics/sql/get-started-power-bi-professional

Or use this one:

https://insightsquest.com/2020/05/31/power-bi-pro-guide-to-synapse-analytics/

Nontaphat Saksathianpong 21 Reputation points

2020-08-20T12:38:06.637+00:00

Hi pituach, I can connect Power BI with SQL pool but in my case delta table is stored in "Spark pool". So delta table is not shown in Power BI, I think it should use another way to connect it. ![19182-annotation-2020-08-20-193443.png][1] Thank you [1]: /answers/storage/temp/19182-annotation-2020-08-20-193443.png
Viraj Jayant 0 Reputation points

2023-10-04T07:03:43.6766667+00:00
Hi

Is this answer still accepted? I have seen a few articles addressing the same but I am not sure if they will solve the use case or not.

Please review the following links and update the answer if required:

Link the PowerBI Workspace to Azure Synapse Workspace via Linked Services (Reference)

Connect serverless SQL pool to Power Bi (Reference)

Community Post (Reference)

Share via

How to connect Azure Synapse spark pool with Power BI ?

1 additional answer

Your answer