Export data from azure synapse serverless pool VIEWS to PowerBI

[Anonymous]

Hi,

I am trying to get data from azure synapse serverless pool by (creating views) to PowerBI. In synapse the query is running fine even view is created perfectly. But when i use azure sql database connector to connect to azure synapse in power bi on preview data loading it shows data loading when i click load it shows data is loading waiting message.

What should i do in this case. I am using report server and i even tried using dataflwos in pwoerbi service the data is not loading

Please help

[v-jingzhang]

Hi @Anonymous 

See if this doc helps:

Tutorial: Connect serverless SQL pool to Power BI Desktop & create report - Azure Synapse Analytics | Microsoft Learn

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!