cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jon00320
Regular Visitor

creating environment and using connector

Hello,

 

I have created a new environment and within this, I cannot connect to mySQL database, however, in my original environment (plans: 365, community), there is not such issue.

 

Thanks in advanced

14 REPLIES 14
Jeff_Thorpe
Super User
Super User

Could this be a license issue because the MySQL is a premium connector and would require you to have a per user or per App/Flow plan. The seeded license that comes with O365 doesn't cover premium connectors. 



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

Thanks for the response, however, when being in the original environment it connects to mysql database but in the newly created environment it does not connect.

 

I have both 365 plan and community plan in my profile

GarryPope
Impactful Individual
Impactful Individual

Hello @jon00320,

Just wanted to know if you've set any Data Loss Prevention (DLP) Polices on any of the environments?

So one environment might allow all connectors, whereas the other environment might block a connector.

Microsoft Docs on DLP polices can be found here.

Thanks very much and good luck,

Garry

 

Thanks for the reponse, no DLP policies have been defined

Is there a data gateway involved?



--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.
GarryPope
Impactful Individual
Impactful Individual

Hello @jon00320

Thanks for replying about the DLP policy not being in place. I'm just guessing now, so my below might not be helpful, sorry.

In your original message you said you had an environment which you could connect to mySQL database connector. What is the environment type of the original environment, was it "Developer" or something like that, which used your "Community Plan" license, which allowed you to connect to premium connectors? See below:
https://docs.microsoft.com/en-us/powerapps/maker/dev-community-plan.
I believe you only get a single environment for with the Community Plan license.

Whereas your other environment is a different environment type, such as sandbox or production, and not using your Community Plan license, only your "365 plan", hence the ability not to use a premium connector, if the license is something like "Office 365 E5 plan" license, as this doesn't allow premium connectors. A link on this page will download the license guide.

What is the exact name of your 365 plan please?

Again, this is just a guess.

Thanks very much,

Garry

Yes, there is gateway to get to mySQL data

Hello,

 

I can see, in my plan option two of them

 

Power Apps for Office 365
Power Apps Community
 
But not sure if one of the environments is associated with one of the plan and the other with the other plan, I do not know if there is a place to check this information.
 
Thanks,

On the other hand, do you know if there is any limitation for using a gateway (for using mySQL) in either both of the plans:

 
Power Apps for Office 365
Power Apps Community
 
?
 
Thanks

Helpful resources

Announcements
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

Users online (28,030)