
Announcements
I would like to set up a connection/query against an elastic table in Microsoft Dataverse in Power BI, in order to build reports base on the data.
As I understand, the date resides in a Cosmos DB, so I tried to use ExecuteCosmosSqlQuery to query the data. I am wondering, if this is possible at all.
What I tried until now is executing the following query, where I get an error:
GET https://ngl-dev-usa.crm.dynamics.com/api/data/v9.2/ExecuteCosmosSqlQuery(
QueryText=@p1,
EntityLogicalName=@p2,
QueryParameters=@p3)?
@p1='select * from wo_elastictable'
&@p2='wo_elastictable'
If I am trying to add a connection to Cosmos DB in Power BI I am asked for a key, which I don't have. I also cannot find any instances of Cosmos DB in the Azure Portal.
Does anybody face such scenarios?