Forum Discussion

ranaankit's avatar
ranaankit
Frequent Visitor
9 years ago

Could not load data for this visual - ERROR while connecting to SSAS Tabular CUbe Enterprise Gateway

Hi Team,
 
We are facing the below mentioned issue while running report.
Gateway is configured properly and is online
Data Source is Connected
Cube Model is loaded i.e. I can see all the Tables of Cube
But no data is visible. Every report is failed with the below error: 
Couldn't load the data for this visual
 
Couldn't retrieve the data for this visual. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.

 

Activity ID420d6259-b76c-812b-eb59-72311909da86
Request ID931446e5-c56f-1e1d-2c4e-b5f7416fe1d2
Correlation ID2b7e87a4-1a3b-5b72-a19c-fe0a62a7af90
TimeThu Jul 20 2017 15:25:10 GMT+0530 (India Standard Time)
Version13.0.1930.145
Cluster URIhttps://wabi-south-east-asia-redirect.analysis.windows.net

 

5 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    Might be an issue with the Service. Would post an unhappy face to support and see what they say.

    • ranaankit's avatar
      ranaankit
      Frequent Visitor
      9 years ago

      The above error got resolved but not we are getting the Connection Issue with Cube

       

      SSAS Trace is showing Incorrect Username and Password to Cube

      I have checked the UPN both the UPN is same my userid on Power BI Service is also my Email Address and when I run command whoami /upn on command promt it is also showing same email id 

      Gateway is up and running and Datasource is also connected

       

      But when I am trying to Get Data on Power bi Service using the same Cube it is showing the below error

       

      Support for Analysis Services Connector has ended, and databases connected using this method no longer appear in this list. Only databases connected using a data gateway appear. To upgrade, follow the steps here.
      Servers
      Something went wrong
      Technical details:
      Activity ID: a9cf5733-36d6-e73e-e499-9e61cc399cef
      Request ID: 6b8420ff-3452-eebc-6057-8a3522c0a79f
      Date: 2017-07-21 11:02:37Z (UTC)
      Error text: The following system error occurred: The user name or password is incorrect.
      Cluster URI: https://wabi-south-east-asia-redirect.analysis.windows.net

       

      • v-caliao-msft's avatar
        v-caliao-msft
        Microsoft Employee
        9 years ago

        Hi ranaankit,

         

        For this error message, when adding SSAS data source under Gateway, which username and password do you input? If you use a different account to sign in Power BI Service, and use Get Data to connect to the ssas data source, you would need to add this account in the Users tab of the data source under gateway in advance.

         

        Besides, please check that if the email address you use to sign in Power BI Service matches a defined UPN within the local Active Directory Domain. If a match cannot be found, the above error could occur, and you can use “Map user names” feature to solve this issue. For more details, please review this article: Manage your data source - Analysis Services.

         

        Regards,

        Charlie Liao