web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Power BI Desktop - not...
Microsoft Dynamics AX (Archived)

Power BI Desktop - not enough Memory available while connecting to dynamics ax perspective SSAS

(0) ShareShare
ReportReport
Posted on by Community Member

Hi,

I am on Microsoft Dynamics AX 2012 R3 and have created a perspective, then deployed to SSAS database.

Now i am facing following error in powerbi desktop while accessing this perspective. Please help me on it. thanks.

DataSource.Error: AnalysisServices: Server: The operation has been cancelled because there is not enough memory available for the application. If using a 32-bit version of the product, consider upgrading to the 64-bit version or increasing the amount of memory available on the machine.

*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    I am just relating three tables having less than 1000 rows in each table.

  • Verified answer
    Community Member Profile Picture
    Community Member on at

    you will want to use a SQL Server Business Intelligence Development Studio or SQL Server Data Tools with this install and follow the pre-requisites of the Power BI.  There are many MSDN docs.  Let me know you want me to email a pre-req document over to you.

  • Community Member Profile Picture
    Community Member on at

    Ok. thanks. Apparently the problem was with my cube table and view relations which i fixed and now i am not getting this memory error.

    It seems because of cartesian product, it was trying to fetch a lot of data.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Priya_K Profile Picture

Priya_K 4

#1
Martin Dráb Profile Picture

Martin Dráb 4 Most Valuable Professional

#3
Ali Zaidi Profile Picture

Ali Zaidi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans