web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / SQL connetion > Power ...
Power Automate
Unanswered

SQL connetion > Power query

(0) ShareShare
ReportReport
Posted on by 82

Hi Experts,

 

I was trying to connect SQL(on-premises) connection  > Transform data using Power Query & I'm getting : "You don't have permission for on premises data gateway. Please request permission from the owner of the gateway". As per my knowledge I do have access to on premises data gateway but not sure why I'm getting this message .. Any suggestions ? 

FYI.. I was successfully connected to SQL [Get rows, Get Tables] connections. and fetch the info

 

Thanks

S.P

 
 

 

Categories:
I have the same question (0)
  • abm abm Profile Picture
    32,985 Most Valuable Professional on at

    Hi @Shashankpuli 

     

    Check this link and might be useful

     

    Solved: SQL Connection Problems - Power Platform Community (microsoft.com)

     

    Thanks

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 474

#2
11manish Profile Picture

11manish 268

#3
David_MA Profile Picture

David_MA 243 Super User 2026 Season 1

Last 30 days Overall leaderboard