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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
LloydJHarris
New Member

Refresh Credential Problem - SQL Server Analysis Services

Hi,

 

I'm having trouble getting my published report to refresh. The report uses a SQL Server Analysis Service database connection provided to us by our company's point of sale service provider (they have given us the server name and a username / password login detail). Power BI Desktop connects to the server without issue and I can refresh my queries from there.

 

However, after publishing the report, it can't refresh. Under data source credentials, the server details are correct however it will only allow me to choose the "WindowsWithoutImpersonation" authentication method (this is the only authentication method available in the dropdown).

 

I would think the authentication method should be Basic - to use the username / password we have. Is there anything I can do to correct this? I'm not sure if the issue lies in settings for Windows or Power BI; or if there is a limitation for the type of server connection we have been provided.

 

(I'm currently using a trail version of Power BI Pro while I get this to work).

 

Thanks!

 

 

1 REPLY 1
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@LloydJHarris,

Do you connect to SSAS tabular model or Multidimension model in Power BI? Are you able to refresh your dataset when you configure on-premises gateway instead of personal gateway and add the SSAS data source within the on-premises gateway?

You can follow the guide in the article below to add SSAS data source under on-premises gateway.
https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-enterprise-manage-ssas/

Regards,

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!