Azure-Social-Media-Analytics-Solution-Accelerator Power BI Connect

Question

Azure-Social-Media-Analytics-Solution-Accelerator Power BI Connect

Francois 0

Hi, Hope someone can assist... I have deployed and configured the Azure-Social-Media-Analytics-Solution-Accelerator as described in https://github.com/microsoft/Azure-Social-Media-Analytics-Solution-Accelerator#getting-started As far as I can tell everything is working and configured correctly. the only issue I'm having is having PowerBI connect to Synapse - I have tried a few scenarios but can't seem to get it to work .. Any suggestions? Thanks!

Vinodh247 34,741 Reputation points MVP Volunteer Moderator

2024-02-25T01:40:19.9366667+00:00
what error are you getting when trying to connect?

Check if the endpoint is correct. Try connecting the endpoint through Azure Data Studio or SSMS with the same credentials you have used in the PBI connection with Synapse.

Check if any firewall exception has to be made

Most probably this would be permissions or connectivity issues only.
Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2024-02-28T08:41:25.0733333+00:00

@Francois Following up to see if the below answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

1 answer

Your answer

Vinodh247 34,741 Reputation points MVP Volunteer Moderator

2024-02-25T01:40:19.9366667+00:00

what error are you getting when trying to connect?

Check if the endpoint is correct. Try connecting the endpoint through Azure Data Studio or SSMS with the same credentials you have used in the PBI connection with Synapse.

Check if any firewall exception has to be made

Most probably this would be permissions or connectivity issues only.
Smaran Thoomu 24,260 Reputation points Microsoft External Staff Moderator

2024-02-28T08:41:25.0733333+00:00

@Francois Following up to see if the below answer was helpful. If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Answer 1

Hi @Francois

Thank you for using Microsoft Q&A platform and thanks for your question.
Based on your query, it seems that you have deployed and configured the Azure-Social-Media-Analytics-Solution-Accelerator and are having trouble connecting Power BI to Synapse. To connect Power BI to Synapse, you need to have the necessary permissions and access rights. Please ensure that you have followed the instructions in the Azure-Social-Media-Analytics-Solution-Accelerator documentation correctly.

Regarding the scenarios you have tried to connect Power BI to Synapse, could you please provide more details? This will help us understand the issue better and provide you with relevant technical information.

In the meantime, you can refer the below Azure documentations:

creating a Power BI report using Apache Spark and Azure Synapse Analytics
linking a Power BI workspace to a Synapse workspace Hope this helps. Do let us know if you any further queries.

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

If this answers your query, do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.

Share via

Azure-Social-Media-Analytics-Solution-Accelerator Power BI Connect

1 answer

Your answer