Invalid credentials - Authentication to Dataverse connectors (Power Query Import Mode)

(0) Share

Report

Posted on by Arnaud Lebet

I am encountering issues with my Customer Insights environments when I am trying to connect to Dataverse through the Power Query connector

I get the below message even if the user is valid. I used to connect to both the environment domain (dataverse tenant) and CI. Both environment are created under the same tenant.

Does

I have the same question (0)

All responses (14)

Answers (1)

FrancisRomstad 205 on at

Like (0)

Report

RE: Invalid credentials - Authentication to Dataverse connectors (Power Query Import Mode)

Are you connecting through:

Going through Microsoft Power Query should also work, but the Microsoft Dataverse setup is the way to go now.

Was this reply helpful? Yes No
Arnaud Lebet 17 on at

Like (0)

Report

RE: Invalid credentials - Authentication to Dataverse connectors (Power Query Import Mode)

Thanks Francis,

Originally, my issue is that when using Microsoft Dataverse Import Mode, something happens during the data ingestion that adds up extra return carriages to records. Which eventually cause that only a small portion of records can be used in the unification process. (3 out of 15k)

This issue has been mentioned several times in other conversations. However, no clear fix has been proposed apart from cleaning the data upfront. I am now trying to do this cleaning in ingesting the data through Power Query that would allow me to remove these inconvenient extra return carriages.

Please let me know if you see any other solutions for the my original issue.

Thanks

Arnaud

Was this reply helpful? Yes No
Suggested answer

FrancisRomstad 205 on at

Like (0)

Report

RE: Invalid credentials - Authentication to Dataverse connectors (Power Query Import Mode)

Hi Arnaud

I think you will be able to solve you issues following my suggestions in this post.

community.dynamics.com/.../not-able-to-import-dynamics-crm-contacts-into-ci

Hope it makes sense.

-Francis

Was this reply helpful? Yes No
Arnaud Lebet 17 on at

Like (0)

Report

RE: Invalid credentials - Authentication to Dataverse connectors (Power Query Import Mode)

Hi Francis,

this is precisely where I am stuck. This 2) bullet --> Connecting to Power Query but not able to connect because of invalid credentials. I cannot connect to Dataverse with the Power Query Import Mode.

Any suggestion on the way to go here ?

Thanks

Arnaud

Was this reply helpful? Yes No
Suggested answer

FrancisRomstad 205 on at

Like (0)

Report

RE: Invalid credentials - Authentication to Dataverse connectors (Power Query Import Mode)

Hi Arnaud

Are you using this connector for the second step?

This is the one to go for.

Was this reply helpful? Yes No
Arnaud Lebet 17 on at

Like (0)

Report

RE: Invalid credentials - Authentication to Dataverse connectors (Power Query Import Mode)

Thanks for your quick feedback.

I don't have this connector available. I am using this one:

Was this reply helpful? Yes No
Verified answer

FrancisRomstad 205 on at

Like (0)

Report

RE: Invalid credentials - Authentication to Dataverse connectors (Power Query Import Mode)

Ok ... that's the reason ..

I believe you need to create a ticket on this. I would think this connector was turned on for all CI instances now.

And you did create a data source based on

The data lake connector will get data from output of the first data source.

-Francis

Was this reply helpful? Yes No
Arnaud Lebet 17 on at

Like (0)

Report

RE: Invalid credentials - Authentication to Dataverse connectors (Power Query Import Mode)

Ok, thank you. I will create a ticket for this then.

Yes I did also create a data source using the Microsoft Dataverse Import Mode but there I have the issue that the data that I am ingesting is corrupt and cannot be used in the unification process.

What do you mean by "The data lake connector will get data from output of the first data source" ?

Arnaud

Was this reply helpful? Yes No
Suggested answer

FrancisRomstad 205 on at

Like (1)

Report

RE: Invalid credentials - Authentication to Dataverse connectors (Power Query Import Mode)

Hi Arnaud,

The data lake connector that you are missing will connect to the data lake data created by your "Microsoft Dataverse" import method.

So the first import method creates the data lake and updates that one-to-one with dataverse entities you selected. Then your Dataverse - Data Lake (preview) will connect to that data lake and you can transform with Power Query on that data.

-Francis

Was this reply helpful? Yes No
John Wiese on at

Like (2)

Report

RE: Invalid credentials - Authentication to Dataverse connectors (Power Query Import Mode)

no, this is not correct. These are two totally different methods and unrelated.

The Power Query -> Dataverse connector uses the connector to get the meta data for the entities you select from your dataverse, allows you to transform that data, then imports the transformed data into the CI managed (or your data lake in the BYODL scenario) for use within CI.

The "Connect to Dataverse" method simply lets you choose which entities you want to use within CI and retains a link to the Dataverse datalake. Whenever we need to use that data (M3, or to build a measure, segment, activity) we connect to the Dataverse and pull the current (complete, all fields, all rows) dataset perform the task and then discard the data from memory.

They are in no way linked together. You can do one, or the other...or both.

Was this reply helpful? Yes No