cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
SuhitMange Frequent Visitor
Frequent Visitor

SSAS Cube connecting to power bi service but its not refreshing there.

Hi,

I have created a SSAS cube using SSDT 2015. The size of the Cube is approximately 3.3 GB and it has 10,04,48,386 records. Now when connecting this Cube with Power BI desktop using the Import option it does not gets connected properly and i get the memory issue showing in the error. I have tried to create partition in Cube where the partition contains only 1 month's data which is around 4.7 million records and then tried to connect that partition with Power BI desktop and i also publish this dataset to the server. Now after publishing the dataset when i refresh it manually or when i schedule it, it gives me an error saying,"Cannot connect to the mashup data source. The following system error occurred: The name provided is not a properly formed account name." What can be the problem?

 

 
2 REPLIES 2
Moderator v-sihou-msft
Moderator

Re: SSAS Cube connecting to power bi service but its not refreshing there.

@SuhitMange

 

As the error message said, "The name provided is not a properly formed account name.". Please use SQL Profiler to fetch the accessing users' <EffctiveUserName>, if it doesn't match your local "domain\account", please use "map user name" to make your Power BI account match your local domain acocunt for your SSAS data source.

 

For more details, please refer to document: Manage your data source - Analysis Services

 

Regards,

SuhitMange Frequent Visitor
Frequent Visitor

Re: SSAS Cube connecting to power bi service but its not refreshing there.

How to check the accessing users through the SQL Profiler? When to do this task, while we are refreshing the dataset in the server?

I did not get how this can be the error, i have checked the user name and server name and everything looks good to me. Cannot connect to mashup datasource error is showing when i check the refresh history.

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 274 members 2,625 guests
Please welcome our newest community members: