Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Unable 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...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
4 years ago

Hi,

Thanks for the reply. I'm still getting same error. 

ujjS_9_0-1645439030292.png

I copied the formula below and pasted in PowerApps DataFlow.

let
Source = CommonDataService.Database("orgXXXXXX.crm4.dynamics.com"),
dbo_cr3b3_query12 = Source{[Schema="dbo",Item="cr3b3_query12"]}[Data]
in
dbo_cr3b3_query12