Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
govindarajan_d
Solution Supplier
Solution Supplier

Generic 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 7
Tom_CA
Frequent Visitor

Hello everyone,

Is there any news about it? I am facing the same situation.

Thanks

Anonymous
Not applicable

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.

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. 

Anonymous
Not applicable

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.

Anonymous
Not applicable

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.

Anonymous
Not applicable

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 .

Anonymous
Not applicable

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 .

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.