Forum Discussion

sivarajan21's avatar
sivarajan21
Post Prodigy
2 years ago
Solved

Calculated Table causes performance issue and dataset refresh fails

Hi,   I have a calculated table called 'Invoice Issues' as below which is derived from the existing Data table: The main purpose of this table is to create a calculated column called 'Status...
Data Protection
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • marcorusso's avatar
    marcorusso
    2 years ago

    When you create a calculated table, the entire uncompressed table must be materialized in memory and then compressed. This could be a memory-intensive operation that works on your PC and fails on Power BI Service.

    You should reduce that table by removing unused columns and remove unnecessary rows - e.g. keep only the rows that have an issue.

    Or compute the column outside of Power BI, so it's processed like other tables segment by segment, reducing the memory requirement at refresh time.

     

marcorusso's avatar
marcorusso
Most Valuable Professional
2 years ago

When you create a calculated table, the entire uncompressed table must be materialized in memory and then compressed. This could be a memory-intensive operation that works on your PC and fails on Power BI Service.

You should reduce that table by removing unused columns and remove unnecessary rows - e.g. keep only the rows that have an issue.

Or compute the column outside of Power BI, so it's processed like other tables segment by segment, reducing the memory requirement at refresh time.