Forum Discussion

huri_khan's avatar
huri_khan
New Member
24 days ago

Can't open file

Hello 

I create a report, save it, and close it. Usually, the report is connected to SQL or Excel.

Then, when I try to open the report, I get the message below.


An error occurred

Method not found: 'System.Thereading.Task.task`1< .... 

 

Last month everything worked fine 

7 Replies

  • ShahRukhSameer's avatar
    ShahRukhSameer
    Icon for Continued Contributor rankContinued Contributor

    Hi huri_khan​,

    I’d suspect the Power BI Desktop installation/version rather than the SQL or Excel connection.

    The important part of the error is the Newtonsoft.Json / System.Threading.Tasks message. That looks like a dependency/version mismatch within Desktop.

    I’d try these first:

    • Update Power BI Desktop to the latest version.
    • If you’re already on the latest version, try repairing or reinstalling Desktop.
    • Check that you don’t have multiple/older Power BI Desktop installations on the machine.
    • If possible, try opening the same PBIX on another machine. If it opens there, that would point pretty strongly to the local Desktop installation.

    Since the report saves successfully but fails when you reopen it, I wouldn’t start rebuilding the connections. I’d troubleshoot the Desktop installation first.

    • huri_khan's avatar
      huri_khan
      New Member

      1. I reinstalling desktop 
      2. On another machine the same problem with the same report. 

      • danextian's avatar
        danextian
        Icon for Super User rankSuper User

        What happens if you import the report to Power BI Service since you are not able to open the file -  are you able to successfully open the report then?

         

  • Hi huri_khan​ - I would not recommend clearing the Power BI cache as the primary solution, and I would not immediately attribute the issue to the SQL/Excel connector.                                                      The specific Newtonsoft.Json.Linq.JToken.LoadAsync(...) “Method not found” error may indicate a .NET/Newtonsoft.Json assembly version or compatibility issue.                                                             To identify the root cause, it would be helpful to confirm the Power BI Desktop version being used and whether the issue occurs with other PBIX files and/or on other machines. This would help determine whether the problem is specific to the report or related to the Power BI Desktop environment.                                                                                                                                      Hope it helps.

    • huri_khan's avatar
      huri_khan
      New Member

      I check on 2 computers, on private and company. 

      On both computers is the same problem.
      I install from Microsoft Store version 2.157.879.0 64-bit


      I make new report: add 2 excel files , try Magane Relationships and become error. 


      Cannot perform interop call to : ... 

       

      Is it possible that a Windows update broke something? The two computers have nothing to do with each other.