Forum Discussion

trevb's avatar
trevb
Icon for Advocate II rankAdvocate II
10 years ago

Object reference not set to an instance of an object

So I have my PowerQuery working perfectly but when I apply and load the "Apply Query Changes" comes back with the error above.  I'm not sure what is causing this but I may have a suspicion.  My query...
Need Help
DataGuy2016's avatar
DataGuy2016
Icon for Advocate IV rankAdvocate IV
9 years ago

This appears as a bug in the desktop release Version: 2.43.4647.541 64-bit (February 2017)

  • Drobinson1's avatar
    Drobinson1
    Icon for Helper III rankHelper III
    9 years ago

    I just recieved the same error.  Trying to link two created columns.  Both are [PartCode]&[Warehouse].

  • igaca's avatar
    igaca
    Icon for Helper III rankHelper III
    9 years ago

    Having the same issue; cannot model anything (get the error when connecting fields to establish relationships).

     

    I skipped the January version due to all the issues folks were reporting, now would like to revert back to December - does anyone have available to share?

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi, It took me a couple of hours to figure why Power BI wasn't creating the relationships out.

      Error message was:

      "Unexpected error Object Reference not set to an instance of an object". (Very informative)

      Checked the data was clean, trying different data sources that were working before, etc. Then I tried creating the relationship in the other direction and it worked without any issues XD.

      With that I mean when I drag and drop from Table A to Table B, the exception occurs; when I drag and drop from Table B to Table A, works.

       

      Hope this helps! 

       

      • Steve88's avatar
        Steve88
        Icon for Advocate I rankAdvocate I
        9 years ago

        Yeah, I found the same worked for me. Seems like an odd new feature.

  • dsandberg's avatar
    dsandberg
    Icon for Advocate I rankAdvocate I
    9 years ago

    IS there a bug open on this topic?

    • DataGuy2016's avatar
      DataGuy2016
      Icon for Advocate IV rankAdvocate IV
      9 years ago

      The Support page is also down.

       

      Its a bad day for the PBI team in Microsoft.

       

      This problem is causing me a lot of pain and I am considering moving to Tableau

      • dsandberg's avatar
        dsandberg
        Icon for Advocate I rankAdvocate I
        9 years ago

        I was able to restore to the Jan 2017 version and correct the issues I was having.