Forum Discussion

ajmonster's avatar
ajmonster
Icon for Helper II rankHelper II
8 years ago
Solved

Dataset won't refresh from Azure SQL

Hello   My dataset won't refresh from the Azure SQL Database. I get the following message when I try the manual refresh on the service:   Message: Microsoft SQL: The SELECT permission was denied ...
Need Help
  • ajmonster's avatar
    ajmonster
    8 years ago

    I figured it out. For some reason the new credentials didn't pass over from Desktop to Service.

v-haibl-msft's avatar
v-haibl-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

ajmonster

 

Please try to grant the SELECT permission on the table. You can refer to this document.

 

Best Regards,
Herbert