
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
Check this link and might be useful
Solved: SQL Connection Problems - Power Platform Community (microsoft.com)
Thanks