Forum Discussion
Super UserGeneric user account for warehouse SQL Endpoint
Usually, we create a generic SQL account for reports so that it is not tied to any personal account. I read from the documentation that SQL authentication is not supported in warehouse. What would be the best way to create a generic account?
I see that we can create service principal in azure and use it, but it cannot be used in Power BI Desktop. Is there any other way?
7 Replies
Hi govindarajan_d ,
Thanks for using Fabric Community.
Can you please explain your ask more clearly? I would like to know few more details so that I can guide you better.Hello govindarajan_d ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .Hi govindarajan_d ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet .
In case if you have any resolution please do share that same with the community as it can be helpful to others .
Otherwise, will respond back with the more details and we will try to help .
- govindarajan_d
Hi Anonymous,
For example, I can create a new SQL user 'dashboard_data_user' and use it as a generic account for all my reports which will use the SQL user authentication while loading data.
How do I do it in Fabric Warehouse, when it doesn't have SQL authentication.
Hi govindarajan_d ,
Thanks for using Fabric Community.
At this time, we are reaching out to the internal team to get some help on this .
We will update you once we hear back from them.
- Tom_CA
Helper I
Hello everyone,
Is there any news about it? I am facing the same situation.
Thanks
