Forum Discussion

uk-roberto92's avatar
uk-roberto92
Frequent Visitor
8 months ago
Solved

Problem sourcing data in Fabric, not in SQL

Hi,   I am trying to source some data from a SQL table in Fabric service. I can access the table via SQL SSML, but not via Fabric, with the same user, getting the following error: The SELECT perm...
Need Help
  • Olufemi7's avatar
    Olufemi7
    8 months ago

    Hello uk-roberto92,

     

    Fabric queries run in the context of the gateway database, so even if your user works in SSMS, it needs explicit permissions in the target database. Grant SELECT on the table (or add the user to db_datareader) in yyyyy, then fully qualify the table in Fabric (yyyyy.dbo.table). This resolves the permission error.

v-prasare's avatar
v-prasare
Icon for Community Support rankCommunity Support
8 months ago

Hi uk-roberto92,

We would like to confirm if our community members answer resolves your query or if you need further help. If you still have any questions or need more support, please feel free to let us know. We are happy to help you.


GilbertQ & Olufemi7 ,Thanks for your prompt response

 

 

Thank you for your patience and look forward to hearing from you.
Best Regards,
Prashanth Are
MS Fabric community support