Forum Discussion

gvega5's avatar
gvega5
Frequent Visitor
5 years ago
Solved

Object reference not set to an instance of an object.

Hi All, 

 

Im getting this error message while trying to conect to a SharePoint File: 

Object reference not set to an instance of an object.

  • SOLUTION - I worked with PowerPlatform support to diagnose the problem.  It seems the issue was introduced in the OCT21 release.  We tried the SEP21 release, and it works properly.  Uninstall OCT21, version: 2.98.6830, and install SEP21 from here:

    https://download.microsoft.com/download/8/8/0/880BCA75-79DD-466A-927D-1ABF1F5454B0/PBIDesktopSetup-2021-09_x64.exe

     

    If you installed PowerBI Desktop from the Microsoft store it will automatically update, but when you install manually, it will NOT automatically update.  Just something to be aware of going forward.  During this troubleshooting, the issue was of course reported and will be addressed in a subsequent release.

7 Replies

  • I can confirm this as an issue as well.  We've been using PowerBI with Excel files stored in Sharepoint for months, and suddenly started experiencing this within the past 12 hours.  I suspect it's an authentication issue that's been recently introduced.

  • SOLUTION - I worked with PowerPlatform support to diagnose the problem.  It seems the issue was introduced in the OCT21 release.  We tried the SEP21 release, and it works properly.  Uninstall OCT21, version: 2.98.6830, and install SEP21 from here:

    https://download.microsoft.com/download/8/8/0/880BCA75-79DD-466A-927D-1ABF1F5454B0/PBIDesktopSetup-2021-09_x64.exe

     

    If you installed PowerBI Desktop from the Microsoft store it will automatically update, but when you install manually, it will NOT automatically update.  Just something to be aware of going forward.  During this troubleshooting, the issue was of course reported and will be addressed in a subsequent release.

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion

    where do you get that error? please share your steps

    • gvega5's avatar
      gvega5
      Frequent Visitor

      When I try to Edit Credentials in Power Query, I get a request from the SharePoint for User Name and Password. Once I input those, I get this error message.

       

       

       

       

       

      • vanessafvg's avatar
        vanessafvg
        Icon for Community Champion rankCommunity Champion

        are your credentials correct?  have you put the wrong details in maybe?    have connected successful before?

         

        make sure you have the correct credentials 

        delete the crednetials you have in your data source settings.

         

  • Moshood_AK's avatar
    Moshood_AK
    Regular Visitor

    I'm currently experiencing this error while trying to open my Power BI file. Any help on how to resolve this?