Forum Discussion

Nuno_Santos's avatar
Nuno_Santos
Advocate I
1 year ago
Solved

An unexpected error occurred (file '', line , function '')

After updating to the May 2025 Report Server, the error 'An unexpected error occurred (file '', line , function '')' is occurring in reports that had been deployed for a long time. It appears that t...
"Power BI Report Server May 2025”
  • Nuno_Santos's avatar
    Nuno_Santos
    1 year ago

    Hi,

    After installing on several devices and noticing that some returned errors while others didn’t, I compared the system information of each one and found that the issue, in this case, is related to AVX CPU extension support. One of the VMs didn’t inherit this extension from the host, and once it was enabled, the error disappeared.

    We can conclude that the error is related to CPUs lacking the AVX extension.
    Best Regards.

Nuno_Santos's avatar
Nuno_Santos
Advocate I
1 year ago

Hi, still working on it.

 

I have run some tests and minimized the data to reproduce the error with a CSV file, created in a plain text file.
 
The text file contains only these lines:
A,B
1845,330679
1845,330679
1845,330679
1845,330679
1845,330679
1845,330679
1845,330679
1845,330679
 
the 3 steps applied to file load:
= Csv.Document(File.Contents("D:\work\TestFile.csv"),[Delimiter=",", Columns=2, Encoding=65001, QuoteStyle=QuoteStyle.None])
= Table.PromoteHeaders(Source, [PromoteAllScalars=true])
= Table.TransformColumnTypes(#"Promoted Headers",{{"A", type number}, {"B", Int64.Type}})
 
column A was set as a decimal and column B as a whole number.
 
I created the measure:
measure= CALCULATE(COUNT(TestFile[B]),TestFile[A]>0)
 
and a visual list with only one column containing the created measure and the error occurs.
 
the error disappears if I do one of the following:
  • remove at least one line of the file (all lines are equal)
  • change column A type from decimal to whole number
  • change measure removing TestFile[A]>0, or changing to TestFile[A]=0 or TestFile[A]<0, but TestFile[A]>=0 the error remains (the '>'  operator is causing the error)

Thanks.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Nuno_Santos ,
Thank you for keeping us updated on the issue and confirming that it’s still unresolved. Once you hear back from the support team, please do share the response here, it will be helpful for others who may encounter a similar issue.
Thank you.

  • Nuno_Santos's avatar
    Nuno_Santos
    Advocate I
    1 year ago

    Hi,

    After installing on several devices and noticing that some returned errors while others didn’t, I compared the system information of each one and found that the issue, in this case, is related to AVX CPU extension support. One of the VMs didn’t inherit this extension from the host, and once it was enabled, the error disappeared.

    We can conclude that the error is related to CPUs lacking the AVX extension.
    Best Regards.

    • Anonymous's avatar
      Anonymous
      Not applicable
      1 year ago

      Hi Nuno_Santos ,
      Thank you for the update — glad to hear the issue has been resolved!
      Please consider accepting your answer as the solution so others facing a similar issue can easily find it.

      Regards,
      Pallavi.

      • Anonymous's avatar
        Anonymous
        Not applicable
        1 year ago

        Nuno_Santos answer is not the resolution , it might be spotting what is the problem.
        What am I supposed to do if I'm using Mac and my CPU doesn't support AVX ?
        Anonymous 

    • SWADOOD's avatar
      SWADOOD
      New Member
      1 year ago

      this was the issue at our end the VM Machine , cpu was selected as core 2 duo...
      which does not support avx extension....
      when updated to when updated to xeon gold 6226R..
      the visual started to showing again..

    • gpoelmans's avatar
      gpoelmans
      Frequent Visitor
      1 year ago

      We have had the same issue. Enabling the AVX CPU extension support resolved it. 
      Thanks Nuno_Santos for finding and reporting this. 

Related content