Forum Discussion
Is it possible to create a connection to an SQL endpoint via Service Principal?
Hi vasotsich ,
I actually tried this myself just now and for me it worked. I realised that I was only able to add the service principal as a contributor to the workspace after I had enabled the setting "Service Principals can use Fabric APIs" in the admin portal.
After that I could create a connection in Fabric with Service Principal as the Authentication method and SQL Server as the connection type. Lastly, I assigned this cloud connection to my semantic model under the setting Gateway and cloud connection. The refresh afterwards worked out, too.
I might set up a quick blog article walkthrough in the upcoming days with a few screenshots.
But until then, please let me know if the way I described it worked out for you as well 🙂
[Edit, 2024-10-13]: Here the article:
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
Most Valuable ProfessionalHi vasotsich ,
I actually tried this myself just now and for me it worked. I realised that I was only able to add the service principal as a contributor to the workspace after I had enabled the setting "Service Principals can use Fabric APIs" in the admin portal.
After that I could create a connection in Fabric with Service Principal as the Authentication method and SQL Server as the connection type. Lastly, I assigned this cloud connection to my semantic model under the setting Gateway and cloud connection. The refresh afterwards worked out, too.
I might set up a quick blog article walkthrough in the upcoming days with a few screenshots.
But until then, please let me know if the way I described it worked out for you as well 🙂
[Edit, 2024-10-13]: Here the article:
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/