Unable to create database in production environment

[Anonymous]

Hi all

I've read a few similar messages here but I can't find what, if any, solution has been found.

We have an Office 365 Small Business subscription which obviously includes a certain level of PowerApps access.  Back in June I went on a Microsoft training course called App In A Day and, in preparation, managed to create a new 'test' environment complete with CDS database.  I completed the course with no issues, managing to build model-driven apps etc.

However, when I try to create a CDS database in our default environment, I get the following error:

The default environment’s region ('europe') is different from your company’s Azure Active Directory home location ('unitedkingdom'). Creating a database here isn’t available.

I have tried deleting the 'test' environment so that there's only the one but it doesn't make any difference - I remain unable to create the database.

Am I doing something wrong?  Is there a limitation from our PowerApps subscription and do you need something in addition to the base Office 365 subscription to be able to use it?  I'm quite a novice at this and although I've searched I can't find anything clear-cut to guide me.

Thanks!

[CWesener]

Adding @ManasMSFT from the admin team to assist.

[v-xida-msft]

Hi @Anonymous,

Which Office 365 license do you have for your PowerApps?

Do you want to create a database within your PowerApps default environment?

Based on the error message, it seems to tell that the region of your PowerApps default environment is different from your company's Azure Active Directory home location.

Currently, you can only create a database in a Production or Trial environment, which is in the same region as your Azure AD or Office 365 tenant's home region. We are working on enabling creation of database in environments created in a different region than your tenant's home location.

Also, you currently cannot create a database in the default environment and an individual environment (created with PowerApps Community Plan).

More details about Regions within PowerApps, please check the following article:

https://docs.microsoft.com/en-us/powerapps/administrator/regions-overview#what-features-are-specific-to-a-given-region

In addition, if you want o create a environment within PowerApps, your sign in account must have PowerApps Plan 2 license at least. If you only have PowerApps for Office 365 license on your side, you could not create an environment within PowerApps, also you could not create a CDS database within your PowerApps environment.

More details about the prerequisites for creating an environment, please check the following article:

https://docs.microsoft.com/en-us/powerapps/administrator/create-environment#prerequisites

More details about license and permision requirements for creating a CDS database within PowerApps, please check the following article:

https://docs.microsoft.com/en-us/powerapps/administrator/create-database#license-and-security-permissions

Best regards,

Kris

[Anonymous]

Hi Kris

Thanks very much for your reply.

In answer to your questions, I think we may have two issues.  Firstly, our AAD region is set to United Kingdom whereas our PowerApps region appears to be Europe.  I'm not sure how this happened, unless it was an error I made.  In our trial environment I made a point of selecting 'United Kingdom' when creating the environment.

As for our licence, we do only have a PowerApps for Office 365 licence, although we also have a trial PowerApps Plan 2 licence.  Can I assume that this is part of the problem?

Kind regards

Sam