To homepage To homepage
Solved

Microsoft Dataverse Connection

  • 10 January 2024
  • 3 replies
  • 141 views
anders.e.jonsson
Rank
Userlevel 1
Badge +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

icon

Best answer by Christian Hauggaard 2 February 2024, 10:05

View original
Anders

3 replies

Christian Hauggaard
Rank
Userlevel 6
Badge +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
Rank
Userlevel 1
Badge +1

Hi Christian,

Thanks!

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

BR

Anders

Anders
Christian Hauggaard
Rank
Userlevel 6
Badge +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

Reply


Terms and ConditionsCookie settings