Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
One of my client encounter a memory issue when developing her report and I can't get why.
For the context her Power BI report is connected to a Tabular stored on On-Prem server and the access is through Connect Live.
The viz that fails is a "huge" table with 47 columns. It's obviously too much but I want to understand why it's failing.
Sometimes she gets this error (not always) :
The point that I don't understand is, as far as I know, a tabular is directly loaded in memory. So if we can access it, this means there is now memory issue. Am I right there ?
So if this viz fails, is it because there is a limitation in Power BI itself, considering rows or columns number ?
Thank for your insights.
Solved! Go to Solution.
Hi @Anonymous ,
When we receive a Memory Allocation issue either at Power BI Desktop either at Analysis Services Tabular then it is not a limit of them it is a limit of machine where they are running (your PC, server etc.).
When Power BI connected to a source Live or via DirectQuery then each visual sends a request to a source and a result is returned to a visual, but it can't cause memory issue here. In your case your huge visual sends a DAX request to Tabular which consume too much RAM (memory) at a machine where Tabular is running.
In order to solve this you have 4 options:
Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!
You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups
Hi @Anonymous ,
When we receive a Memory Allocation issue either at Power BI Desktop either at Analysis Services Tabular then it is not a limit of them it is a limit of machine where they are running (your PC, server etc.).
When Power BI connected to a source Live or via DirectQuery then each visual sends a request to a source and a result is returned to a visual, but it can't cause memory issue here. In your case your huge visual sends a DAX request to Tabular which consume too much RAM (memory) at a machine where Tabular is running.
In order to solve this you have 4 options:
Regards,
Ruslan Zolotukhin (zoloturu)
BI Engineer at Akvelon Inc. / Kharkiv Power BI User Group Leader / DAX & Power BI Trainer
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
It was useful? Press Thumbs Up!
You are from Ukraine? If yes then welcome to Power BI User Group - KhPUG website. Other country? Check and find proper one - Power BI User Groups
Hi @Anonymous ,
Taking into account the specifications of each model without knowing the full details is difficult to assist however believe that the best option you have is to click on send a frown, that will send out an e-mail to PBI support with all the details and they will reach out to you and explain waht is going on.
Another option is to replicate this post on the issues part of the forum and the msft team will for sure get back to you.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |