Unanswered

Dataflow cannot load the systemuser table

(2) Share

Report

Posted on by powerpat123

I am trying to create a DataFlow to retrieve information from the systemuser table. In Power Query the table will not load. I get: "Evaluation was cancelled"

There are less than 350 users in the table

let
Source = CommonDataService.Database("XXXXX.crm3.dynamics.com", [CreateNavigationProperties = null]),
Navigation = Source{[Schema = "dbo", Item = "systemuser"]}[Data]
in
Navigation

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (1)

Report

HI @powerpat123 ,

I am not a Power Query expert in any way but this article is going after the information using NativeQuery which I thought might help you here. https://learn.microsoft.com/en-us/power-query/connectors/dataverse#using-native-database-queries-with-dataverse

Was this reply helpful? Yes No
365-Assist 2,324 Moderator on at

Like (1)

Report

I have the same problem and have logged a support ticket with MS. My error looks like this:

Was this reply helpful? Yes No
LinhPham 2 on at

Like (0)

Report

Hi @365-Assist , May I know if there is any update for this case?

Was this reply helpful? Yes No
365-Assist 2,324 Moderator on at

Like (0)

Report

I just got a response from MS Support saying that the issue is quite complicated and that they are still working on it.

Was this reply helpful? Yes No
365-Assist 2,324 Moderator on at

Like (3)

Report

I just received the following update from MS Support.

--------------------------------------------------------------------------------------------

In Dataverse, it is creating issues for the Power Query data model because of the enormous number of relationships it has to other tables. If you only want to bring in the data and don't need to work with the relationships to other tables, you can use the workaround by adding a CreateNavigationProperties=false option to your data source function.

In other words, as below:

CommonDataService.Database("servername.crm.dynamics.com", [CreateNavigationProperties = false])

Also, you need to change the Power Query code in advanced editor.

1 people found this reply helpful.

Was this reply helpful? Yes No
guillem95 on at

Like (0)

Report

Thanks @365-Assist!! It works 😀

Was this reply helpful? Yes No