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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ranaankit
Frequent Visitor

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

 

5 REPLIES 5
Jancarlos_Acuña
Regular Visitor

GM, tggau is given access to the server or the user account?

Greg_Deckler
Super User
Super User

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


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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.

 

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

Hi

Username we are using is same as logon user, ssas service is also running with same user, user is local administrator, user is also sql admin account.

The error was because of AD server tggau was not provided. When that access is given we are getting another error where we are able to get the cube when using get data but no model.

Ssas trace is showing error "the following error has occured:" thats it no error comment
No logs are even created. Gateway is still online abd connection to data source is successfull.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors