Forum Discussion

ConnorH's avatar
ConnorH
Microsoft Employee
5 years ago

Data refresh fail

Hi All,

 

I hope this is a good section to post about refresh issues. 

 

"Refresh failed:

WLS Projects Dataset has failed to refresh.
Failure details: SharePoint: Request failed: -Sharepoint Link-"

 

I have a  data set which says the authentication failed for accessing an Excel file on a SharePoint site. I have taken the data set and refreshed in the desktop version and the refresh works fine. Then I post it back online and it gives me the same error. I have tried to disconnect and reconnect thinking that maybe that would fix the authentication issue but it doesn't. I have tried searching this issue but no one has an answer to fix this.

 

Update- I have realized that it fails about 70% of the time when posted online. Meaning that sometimes the refresh works just fine other times it wont work and will cause an increased error rate. 

Need Help

7 Replies

  • edhans's avatar
    edhans
    Community Champion
    5 years ago

    What do you mean "I have realized that it fails about 70% of the time when posted online."
    Is this an on-prem SharePoint server?

    How would your data not be posted "online?"

    • ConnorH's avatar
      ConnorH
      Microsoft Employee
      5 years ago

      I meant when the power BI dataset is posted online. So I was meaning I can refresh it on desktop mode.

      • edhans's avatar
        edhans
        Community Champion
        5 years ago

        Ok. The sporadicness of the fail is what is puzzling. Are you mashing it up with any other data? I wondering if the permission levels (private, organizational, etc.) are off, but that only matters if 2+ sources.

         

        Any more details on the error in the service?