Skip to main content

Hi,

 

I have created and populated a small table in Dataverse using a Power App.

There are no problems accessing and reading data from the table with Power BI Desktop.

But I don't really understand how to use CData's connector (Microsoft Dataverse (23.0.8749.0) 64bit). Does anyone know which fields to fill in for the authentication itself? Username and password or equivalent. 

BR
Anders

Hi @anders.e.jonsson 

Please see the following documentation on establishing a connection - there are multiple methods to connect.

In the below example, I am using AzureAD auth scheme

 


Hi Christian,

Thanks!

I have tried, but got some unexpected behaviour. I submitted a request to support

BR

Anders


This issue was resolved by using an App registration and setting the following properties in the data source provider
 
AuthScheme
OrganizationURL
AzureTenant
InitiateOAuth=REFRESH
OAuthClientId
OAuthClientSecret
CallbackURL=http://localhost:33333


Reply