Forum Discussion

Tsanka's avatar
Tsanka
Kudo Collector
10 years ago

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 ...
Need Help
PowerBIGuy's avatar
PowerBIGuy
Responsive Resident
10 years ago

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

 

 

  • Tsanka's avatar
    Tsanka
    Kudo Collector
    10 years ago

    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's avatar
      Tsanka
      Kudo Collector
      10 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

         

        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.