Unanswered

Unable to create table using dataflows in powerapps

(0) Share

Report

Posted on by Keesl

Hi there,

I am trying to create a single table from several tables in a spreadsheet using dataflows in powerapps. If I use my own 365 account, the table is created fine. But I want to use an account we have setup for 365 administration tasks. It throws the following error:

There was an error while creating this table. Details: Failed to create entity with logical name cr959_cheers and object type code -1. Exception: Microsoft.Crm.CrmSecurityException: SecLib::CheckPrivilege failed. User: XXXX, PrivilegeName: prvCreateEntity, PrivilegeId: XXXX, Required Depth: Basic, BusinessUnitId: XXXX, MetadataCache Privileges Count: 3524, User Privileges Count: 908 at Microsoft.Crm.BusinessEntities.SecurityLibrary.ThrowPrivilegeDeniedException(IUser user, RolePrivilege rolePrivilege, ExecutionContext context) at Microsoft.Crm.BusinessEntities.SecurityLibrary.<>c__DisplayClass86_0.<GetMaxPrivilegeDepthForUserAcrossBusinessUnits>b__0() at Microsoft.PowerApps.CoreFramework.ActivityLoggerExtensions.Execute[TResult](ILogger logger, EventId eventId, ActivityType activityType, Func`1 func, IEnumerable`1 additionalCustomProperties) at Microsoft.Xrm.Telemetry.XrmTelemetryExtensions.Execute[TResult](ILogger logger, XrmTelemetryActivityType activityType, Func`1 func) at Microsoft.Crm.BusinessEntities.SecurityLibrary.CheckPrivilegeGlobalDepth(Guid user, Guid privilege, ExecutionContext context) at Microsoft.Crm.Metadata.EntityService.<>c__DisplayClass38_0.<CreateInternalHelper>b__1() at Microsoft.Crm.SqlTelemetryHelper.LogSqlTimes(Action action, String operationName) at Microsoft.Crm.Metadata.EntityService.CreateInternalHelper(EntityCreateInfo entityInfo, MetadataHelper metadataHelper, Boolean shouldCreateOnlyFromReserve, ExecutionContext context). [Entity: Query]

The user account has an office365 E3, PowerBI Pro and Dynamics 365 Team Member license and has the following roles assigned in Dynamics:

Environment Maker

Sales, Enterprise app access

System Administrator

System Customizer

Can anyone see what access or license might be missing from that account?

Thanks,

Kees

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (0)

Sort by

Drew Poggemann 9,287 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Keesl,

The licenses you have applied to this user would not have the ability to create entities. I know you have system administrator setup as the role in the dataverse but Microsoft might be stopping you based on the licenses assigned. You have a team member license assigned which would not have this permission. Did you try assigning this user to a Dynamics 365 for Sales, Power Apps Per App or Power Apps Per User license?

Thanks,

Drew

Was this reply helpful? Yes No
Keesl 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Drew,

Thanks for that. I also have the same dynamics license as that account but I can run the same dataflow. Could that be because I have 365 admin rights?

Regards,

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Keesl,

At this point I am not sure the problem. Overall the roles you have given the user in the Dataverse would have the ability to create the table. Microsoft has really been changing the rules around Team Members and what they can / cannot do in the system (see here). I would try to assign a valid Power Apps license to the user to see if it works.

Another thing to check is to make sure if your environment is secured to a specific security group and if you are in this security group and your new user is not.

Sorry I can't be of more help.

Thanks,

Drew

Was this reply helpful? Yes No
Keesl 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Drew,

The account does have a powerapp pro license associated with it so I am thinking that it must be something to do on the dynamics side as that account has not had anything to do with that.

I'll keep on trying. Thanks for your help.

Regards,

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Keesl,
There are two licenses for Power Apps, Power Apps Per App and Power Apps Per User. I think you are thinking of Power BI Pro?

Just in case you are looking at wrong license.

Thanks,

Drew

Was this reply helpful? Yes No
Keesl 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Sorry Drew,

Not enough sleep. You are correct. I'll look at this again tomorrow. Again thanks for yor help.

Regards,

Kees

Was this reply helpful? Yes No
Keesl 19 on at

Like
a
(1)

Report
Copy link

Link copied!

So another update.

After some sleep, I gave the account the powerapps per user license but again it made no difference. Then my colleague suggested I try to create the same dataflow in PowerBI, with the same bot account. This worked. So I guess it must have something to do with Powerapps. I did exactly the same dataflow query. Next I will need to check if I can access the data.

The quest continues...

Regards,

Kees

Was this reply helpful? Yes No