Skip to main content
To homepage To homepage
Solved

Microsoft Dataverse Connection

anders.e.jonsson
Contributor
Forum|alt.badge.img+1

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

Best answer by Christian Hauggaard

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

View original
Anders
Did this topic help you find an answer to your question?

3 replies

Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

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

 

anders.e.jonsson
Contributor
Forum|alt.badge.img+1

Hi Christian,

Thanks!

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

BR

Anders

Anders
Christian Hauggaard
Community Manager
Forum|alt.badge.img+5

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

anders.e.jonsson
1 person likes this
  • anders.e.jonsson
    anders.e.jonsson

Reply


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings