Forum Discussion
Syndicate_Admin
Administrator
AdministratorUnable to add Dataverse for Teams as source in DataFlows
Hi I'm not able to add Dataverse for teams as datasource in Dataflows. Getting this error. An exception occurred: DataSource.Error: Microsoft SQL: The 'ExecutePowerBISql' message is not supporte...
v-jingzhang
Community Support
Community Support
You may try connecting to Dataverse for teams in Power BI Desktop, then copy its M codes from Advanced Editor and paste it into Power Apps dataflow. Not sure if this would work but you could give it a try.
Connect to and transform Dataverse for Teams data from Power BI - Learn | Microsoft Docs
Additionally, there are some alternative Dataverse connections in this documentation Power Query Dataverse connector.
Hope it helps.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.