Forum Discussion

kcantor's avatar
kcantor
Community Champion
9 years ago

Object not set to an instance of an object

So, I am on version 53 of a pbix file that connects to sql server. It exists in a data group as well as myworkspace. I have republished this file multiple times with no issue until about 2 months ago...
Need Help
kcantor's avatar
kcantor
Community Champion
9 years ago

Anonymous

thanks for trying. I will leave this open and post here if a solution can be found.

Ons's avatar
Ons
Advocate I
9 years ago

Hi kcantor,

 

Try to disconnect and reconnect your account on the Desktop just before republishing your report.

 

I'm working with the 64bit latest version (2.47.4766.801 64-bit (juin 2017)) and I had the same problem as you.

Now it works only if I change the account (to reconnect) just before republishing.

 

Clearly there is a problem with the desktop but changing/reconnecting the account every time we want to republish could be a work around (it worked for me). If it's a problem with the latest versions, I hope it will be fixed in the next ones.

 

Please let me know if it works also for you.

 

  • kcantor's avatar
    kcantor
    Community Champion
    9 years ago

    Did not work for me. I also updated and tried again. Still a no go.

    thanks for the suggestion, though.

    • kcantor's avatar
      kcantor
      Community Champion
      9 years ago

      A new development:

      The original file was in One drive and had been republished from the desktop on multiple occasions. I have another file that was originally in one drive that is now refusing to allow republsih as well. 

      Is there an issue with the latest versions of desktop publishing files that were previously in one drive? I can add the file to one drive but it will not pull in my new measures.

       

      • RushNour's avatar
        RushNour
        Regular Visitor
        9 years ago

        I've also seen this problem and don't think it's anything to do with One Drive. Closing and reopening the file before publishing seems to work for me although from your description this wont help.

         

        I also doubt it's anything to do with your datasets/relationships as you can refresh without a problem. Have you tried republishing from a different machine?