Forum Discussion
Connection from Power BI Desktop to SQL Analysis Services - is there any way to provide credentials?
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 ,
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.
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.