cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
kar_gilson
Level: Powered On

common data service

Hi

 

I am trying to build a flow (sql on premise to cds) but I cannot seem to access cds from the default environment (where I set gateway required for on premise) with message 'It looks like you don't have permission to use the Common Data Service in this environment. Switch to a different environment, or create your own' . I found documentation saying "Gateways and on-premises connections can only be created and used in the user's default environment" .

 

So how do I get to cds? Am I missing something please?

 

Help would be greatly appreciated.

 

Thank you,

Karen.

2 ACCEPTED SOLUTIONS

Accepted Solutions
Community Support Team
Community Support Team

Re: common data service

Hi @kar_gilson,

 

To work with Common Data Service, you would be required to create a Common Data Service Database first under the current environment.

Please check to see if you have an Database under the Default environment, if yes, verify the permission part:

Create a Common Data Service database

Common Data Service security

 

Post back if you have any further questions.

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

kar_gilson
Level: Powered On

Re: common data service

Thank you sorted - it was permissions after all, the only environment I seemed not to have access to was the default!

 

View solution in original post

4 REPLIES 4
Community Support Team
Community Support Team

Re: common data service

Hi @kar_gilson,

 

To work with Common Data Service, you would be required to create a Common Data Service Database first under the current environment.

Please check to see if you have an Database under the Default environment, if yes, verify the permission part:

Create a Common Data Service database

Common Data Service security

 

Post back if you have any further questions.

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

kar_gilson
Level: Powered On

Re: common data service

Thank you for your reply @v-micsh-msftMichael. It won't let me create a database with the message mentioned in post.

  

Thank you for links, if the entities can indeed be created in dev environment, I must be missing something in relation to permissions/security. Hopefully I will find it in links 🙂

 

Thanks again

kar_gilson
Level: Powered On

Re: common data service

Thank you sorted - it was permissions after all, the only environment I seemed not to have access to was the default!

 

View solution in original post

Anonymous
Not applicable

Re: common data service

Hi All, 

 

After creating a flow for on premise sql to cds , were you able to create your flow with delta load functionality. I am able to a complete load but I am looking for delta load feature currently in the progress.

 

 

Thanks 

Ayush

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users Online
Currently online: 337 members 6,460 guests
Please welcome our newest community members: