Generic user account for warehouse SQL Endpoint

[govindarajan_d]

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?

[v-gchenna-msft]

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.

[govindarajan_d]

Hi @v-gchenna-msft,

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. 

[v-gchenna-msft]

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.

[v-gchenna-msft]

Hi @govindarajan_d ,

The best course of action is to open a support ticket and have our support team take a closer look at it.

Please reach out to our support team so they can do a more thorough investigation on why this it is happening: Link 

After creating a Support ticket please provide the ticket number as it would help us to track for more information.

Hope this helps. Please let us know if you have any other queries.

[v-gchenna-msft]

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 .

[v-gchenna-msft]

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 .