cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Tsanka Continued Contributor
Continued Contributor

Refresh data from on-premise multidimensional SSAS

Hi guys,

 

My personal gateway is up and running (refreshing data with on premise MS SQL datasource).

 

I am trying to schedule a refresh of a power bi data with on premise SSAS multidimensional datasource and I cannot do this as when I try to set the scheduled refresh there is no info for the gateway status and there is no datasource for which credentials to be supplied.

 

SSAS_Refresh.png

 

Please advise. Refresh of multidimensional on-premise SSAS is said to be a supported scenario (Refresh data in Power BI) so obviously I am missing something

 

Thanks

Tsanka

 

5 REPLIES 5
Tsanka Continued Contributor
Continued Contributor

Re: Refresh data from on-premise multidimensional SSAS

Just to add that the above behaviour is seen when the pbix is published from the Power BI desktop. If the file is imported, I observe the same error as @paul_pelletier (http://community.powerbi.com/t5/Integrations-with-Files-and/Analysis-Services-refresh-problem/m-p/82...

 

Please advise how to refresh data from on-premise SSAS multidimensional datasource.

 

 

PowerBIGuy Responsive Resident
Responsive Resident

Re: Refresh data from on-premise multidimensional SSAS

Tsanka, have you tried re-entering your credentials? Also what authentication type did you choose within your pbix file?

 

 

Business Intelligence Architect / Consultant
Tsanka Continued Contributor
Continued Contributor

Re: Refresh data from on-premise multidimensional SSAS

Thank you, @PoweBIGuy, for trying to help me.

 

I am using Windows authentification for SSAS (I think SSAS does not support basic one)

 

For the SSAS datasource I am not able to re-enter my credentials and the service cannot refresh the datasource:

Case1.png

 

If I import/publish a report with MS SQL datasource, everything is okay - the information about the gateway and a place where to reenter the credentials.

 

Case2_.png

 

May it be something related to the SSAS - settings, version? Is MS SQL 2012 Standard 64 supported?

 

Thanks

Tsanka

Tsanka Continued Contributor
Continued Contributor

Re: Refresh data from on-premise multidimensional SSAS

I have tried anything that came to my mind - alternative credentials, SSAS server with the full domain name (server.abc.com), etc. and yet - the same result.

 

Obviously there is an issue with the authentification.

 

Is there anybody who is doing refresh of a multidimensional on-premise SSAS datasource in app.powerbi.com?

 

Thanks

Tsanka

dataguy Helper III
Helper III

Re: Refresh data from on-premise multidimensional SSAS

 

I am having a similar issue trying where the data gateway option is disabled.     What am I missing?   I am able to refresh a SQL Server dataset just fine.   This one an SSAS source and a SQL Server Source.

 

 

GatewaySSAS.GIF

 

 

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors