Answered

Office 365 and Common Data Service

Like (0) Share

Report

Posted on 9 Mar 2020 15:14:51 by Community Power Pla...

Hey,

So I have an Office 365 Licence like everyone in my company and I built a rudimentary app to test the possible implementation of the Common Data Service.

I was able to build an app and modify data after giving myself the permissions over the data (unexpectedly needed to, thought since I set it up it would default but nevermind)

Now the problem is, my colleague who has the same licence as me was unable to open the app (it stated that her plan 2 licence had run out and she needed to extend the trial), she can access any other app that I create as long as it doesn't contain CDS references.

I found this weird since I had heard that users only need the most simple licence which I believed to be below Office 365 licences anyway.

Anyone able to confirm/deny/offer a solution?

Categories:

Connecting to Data

Connectors

General Questions

All responses (5)

Answers (2)

Verified answer

wyotim 2,545 on 11 Mar 2020 at 16:20:42

Like (1)

Report

Re: Office 365 and Common Data Service

@Anonymous With Power BI I am pretty sure they have three tiers: Free, Pro, and Premium. These are pretty different from how Power Apps licenses work. Here is a very gross generalization: The Free can be used by a single user but content cannot be shared with others (aside from publishing to the web or exporting to Excel). Pro is a per-user license and enables sharing with other Pro users. Pro is included in the Office 365 E5 license as well. Premium is basically an org-wide license where you pay by user capacity, with different levels of users costing different amount (creators vs. consumers essentially). There are a number of differences in the Pro and Premium levels, but as far as access goes that is a general idea.

I don't think there are any differences at the connection level, though there may be limitations for on-prem database connections in the Free tier.

That said, unfortunately, I don't think there is an equivalent path with Power Apps. The licensing is basically based on having standard connections only (Office 365 route), premium with a limited amount of apps (per-app), or premium with unlimited apps (per-user). Again, I hope that helps!
David Jennaway 716 on 10 Mar 2020 at 12:33:36

Like (0)

Report

Re: Office 365 and Common Data Service

I don't know the details of Power BI licensing, but for CDS connections, each connection is made in the context of the user, and the user needs to have the appropriate license, so I don't think there's an equivalent workaround for CDS
Community Power Pla... on 10 Mar 2020 at 11:39:57

Like (0)

Report

Re: Office 365 and Common Data Service

@v-yutliu-msft @wyotim
Thanks for the replies, my colleague who develops in PowerBI had a problem with PowerBI premium connections and sorted out their problem by increasing their own licence and thus allowed other members of the organisation to access the premium connection without increasing theirs. Is there anything like that in PowerApps that may be able to solve this problem?
Verified answer

v-yutliu-msft on 10 Mar 2020 at 06:07:45

Like (2)

Report

Re: Office 365 and Common Data Service

Hi @Anonymous ,

To use an app connected with CDS, you need to meet two requirements:

1)have premium license (per app plan/per user plan)

I'm afraid the office365 license is not enough. This kind of license could only use standard connectors. While CDS is a premium connector, which needs premium license.

You could check standard connectors here:

https://asia.flow.microsoft.com/en-us/connectors/?filter=&category=standard

You could check premium connectors here:

https://asia.flow.microsoft.com/en-us/connectors/?filter=&category=premium

The doc about license:

https://docs.microsoft.com/en-us/power-platform/admin/pricing-billing-skus

2)have permission of the entity that you use in your app

The permission of the app and the entity is divided.

You need to assign the users who want to use this app the security role with this entity's permission.

Here's a doc about how to assign security role for your reference:
https://docs.microsoft.com/en-us/power-platform/admin/database-security

Best regards,
wyotim 2,545 on 09 Mar 2020 at 17:20:04

Like (1)

Report

Re: Office 365 and Common Data Service

Hey @Anonymous, the Common Data Service is a premium connection (denoted by the little jewel icon in the data connectors section of Power Apps), which means that any user of that app will need either a Power Apps per-app or per-user license (some Dynamics licenses also give access).

Here is some info on the Power Apps licensing. Standard connections, like SharePoint for instance, can be used with Office 365 licensing but premium connections require additional licensing. I hope that helps!