Forum Discussion

odoro's avatar
odoro
Frequent Visitor
8 years ago

Invalid Connection Credentials during Dataset refresh

I get an Invalid Connection Credentials error when trying to refresh my dataset.  The gateway setup shows "Connection Successful" and the gateway is online.  However when I run a refresh on the datas...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

I don't know if this will help but I ran into the same problem and after searching for quite a while, I ended up uninstalling and reinstalling everything.  In case it helps, here are the steps I did to fix the problem.

 

   Save your .PBIX file somewhere

   Uninstall Power BI Desktop and clean registry (removed all related references to Power)

   Uninstall Personal Gateway and clean registry (removed all related references to Gateway)

   Reboot

   Reinstall Desktop and Gateway

   Open the .PIBX file from the Desktop and publish it

   From the Service, setup a scheduled refresh (Edit Credentials and re-selected the Authorization option in the pull down)

 

...at this point, my problem went away and the refresh was working again.  It's kind of drastic but, like you, I searched and searched but no clear answer that helped so that's what I ended up doing to fix the problem.

 

  • ffa's avatar
    ffa
    New Member
    8 years ago

    Hi! 

    I think that my problem is related to the update...
    I open the .pbix file from the Desktop and publish it. Then I refresh the information but in the report refresh only the data, not the calculated columns...
    The solution is to publish the report again but I want that the report refresh automatically...Any idea what I should do?

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hello,

      Your calculated columns should display when you publish.  At least that's been my experience.  I'm not sure of why they require a refresh.

       

      Aside from that, you can setup a scheduled refresh as long as your data is stored in OneDrive, SharePoint Online, or you have a Personal Gateway setup.  Any of those options will allow you to configure a 'scheduled refresh' (which is setup in the Service, not the Desktop).

       

      Hope that helps