Forum Discussion
Datamart and Dataverse for Teams
Hi to everyone ,
I have created a datamart on a workspace ( under premium content )
but when I try to get data from dataverse for Teams I get the following error :
"Credentials are required to connect to the CommonDataService source"
Does anyone knows if connection to dataverse for Teams is not supported ?
Hi stamatisv ,
According to this list, List of all Power Query connectors - Power Query | Microsoft Learn, Dataverse is allowed. However, I know you stated "Dataverse for Teams" - and I know from my experience that "Dataverse for Teams' is woefully inadequate for any sort of real data usage. This article compares Dataverse and "Dataverse for Teams: - Comparing Microsoft Lists, Dataverse for Teams, and Dataverse - Power Apps | Microsoft Learn
I don't find anything specifically that says datamarts won't work, but based on this link with all of the criteria I would bet that datamart does not work with it:
Dataverse for Teams vs. Dataverse - Power Apps | Microsoft Learn
2 Replies
- collinq
Super User
Hi stamatisv ,
According to this list, List of all Power Query connectors - Power Query | Microsoft Learn, Dataverse is allowed. However, I know you stated "Dataverse for Teams" - and I know from my experience that "Dataverse for Teams' is woefully inadequate for any sort of real data usage. This article compares Dataverse and "Dataverse for Teams: - Comparing Microsoft Lists, Dataverse for Teams, and Dataverse - Power Apps | Microsoft Learn
I don't find anything specifically that says datamarts won't work, but based on this link with all of the criteria I would bet that datamart does not work with it:
Dataverse for Teams vs. Dataverse - Power Apps | Microsoft Learn
Thank you for the clarifications
Actually it is clearly stated that Dataverse for Teams permits "Data movement" only for "Dataflows In"
As a result there is no way to use Dataverse for Teams as a datasource for a newly created datamart
