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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
pejohnson
Regular Visitor

Connection from Power BI Desktop to SQL Analysis Services - is there any way to provide credentials?

Hello,

     I'm starting to work with Power BI Desktop and have a situation where I'd like to host a model on a Analysis Services development server that is not joined to a domain.  I did a bit of research and the documentation seems to indicate that Power BI Desktop will always connect to an Analysis Services database using the Windows credentials of the currently logged in user.   Is there any way to instead provide credentials when an end user connects and/or configure impersonation of a local machine account when connecting from Power BI Desktop to Azure Analysis Services?  Thanks in advance. 

1 ACCEPTED SOLUTION

If it helps anyone, I was able to set up the Analysis Server with an HTTP endpoint as described at Configure HTTP Access to Analysis Services on IIS 8.0 | Microsoft Learn, and then created Windows credentials on each user's local machine with the HTTP endpoint and credentials of a Windows login on the server that was part of the Analysis Service's database Reader role

View solution in original post

4 REPLIES 4
v-yinliw-msft
Community Support
Community Support

Hi @pejohnson ,

 

Sorry about that.

As far as I know, for security reason, you should use Windows credentials to connect to AAS, it is by design.

 

Hope this helps you.

 

Best Regards,

Community Support Team _Yinliw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

If it helps anyone, I was able to set up the Analysis Server with an HTTP endpoint as described at Configure HTTP Access to Analysis Services on IIS 8.0 | Microsoft Learn, and then created Windows credentials on each user's local machine with the HTTP endpoint and credentials of a Windows login on the server that was part of the Analysis Service's database Reader role

Hi @pejohnson ,

 

If you solve your question, please accept your answer as a solution to help other people know it easily.

 

Best Regards,

Community Support Team _Yinliw

Thanks for your reply.  I understand that it requires a Windows login, but I was hoping that you could specify the credentials of the user logging in.  For example, I have an Excel workbook with a PowerPivot that connects to my SQL Analysis Services instance, in the workbook connection properties I can specify credentials for a local Windows user that has the Reader role.  I was hoping that Power BI Desktop would also allow you to configure credentials in the connection properties.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors