Issues on loading Azure Synapse sql queries to Powerbi dataflow using Azure sql database connector

[sv00001]

Hi,

I have created sql views for few tables in Azure Synapse workspace and i have loaded them to powerbi dataflow using the Azure sql database connector and i can see the data in the dataflow and done some transformations on the data which includes few merges. but the dataflow is taking 13hrs to successfully complete the refresh. and when I try to append two tables i mean the views which i loaded to the dataflow. it is not allowing me to append the table. "error: This operation is not allowed " message is shown.

am I doing the process in a right way or is there any other method which i can implement.

can anyone please help me in this issue

[Anonymous · Accepted solution]

Hi @sv00001 ,

Please try to do etl operations in Azure Synapse Workspace, then create a Power BI workspace, link your Azure Synapse workspace, and create a Power BI data set that utilizes data in your Azure Synapse workspace.

For more details, you could read related document:  Tutorial: Get started with Azure Synapse Analytics - Azure Synapse Analytics | Microsoft Learn

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.