Forum Discussion

Malps90's avatar
Malps90
Icon for Helper I rankHelper I
6 years ago
Solved

Error Message

Hi All,    i was wondering if sombody could help me i keep reciving the below error message when applying chnages to the query.    Failed to save modifications to the server. Error returned: Ther...
General Comment
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi Malps90,

    What version of power bi are you test? 32bit or 64bit? AFAIK, 32bit applications have limitations on memory resource usage. I'd like to suggest you switch to 64bit If you are work with 32 versions, it allows you to use more memory resources to calculate.

    how much memory can be accessed by a 32 bit machine? 
    In addition, you can also open task manager to track how much idle memory available. It may also cause the issue if your device does not have enough idle memory resources.

    BTW, what type of operations you proceed in query editor? Any complex reference/invoke/looping calculation in your query tables? If this is a case, you can consider using buffer functions(List.Buffer, Table.Buffer) to avoid the memory leak of iterate calculations.

    How and When to use List & Table Buffer? 

    Regards,

    Xiaoxin Sheng

Malps90's avatar
Malps90
Icon for Helper I rankHelper I
6 years ago

Hi, 

 

i am currently using 64bit at present and still recieving the same message. 

 

i am a little lost as to what i need to do to rectify this Error please see image of the error message. 

 

Many Thanks

 

 

mwegener's avatar
mwegener
Icon for Most Valuable Professional rankMost Valuable Professional
6 years ago

Hi @Malps90 ,

 

how much memory do you have?

What is your memory usage? (Task manager)

 

  • Malps90's avatar
    Malps90
    Icon for Helper I rankHelper I
    6 years ago

    Hi when the report was applying the query my memory was nearly at its max and my CPU fluctuates between 70% and 90%.

    The report is extremely big.

    Many thanks

    • mwegener's avatar
      mwegener
      Icon for Most Valuable Professional rankMost Valuable Professional
      6 years ago

      Hi Malps90 ,

       

      Do you need the tables with all columns?
      How many columns do you have?

       

      • Malps90's avatar
        Malps90
        Icon for Helper I rankHelper I
        6 years ago

        Hi, 

         

        The particular table i am applying ot query too i need all columns and there is only aproximately 10 columns however there is alot of tables in the report and i might be able to reduce this down. 

         

        some of the tables have alot of data in them which have alot of caluclated columns in. 

         

        i have been looking at a way to reduce the coding but not sure if that would help. 

         

        Many Thanks