Forum Discussion

jamieo's avatar
jamieo
Microsoft Employee
10 years ago

Error loading Excel file from Sharepoint

I get an error when loading the file into PowerBI.  I've tried multiple times and consistently get this error:   Something went wrong.   Failed to configure selected file Please try again later...
jamieo's avatar
jamieo
Microsoft Employee
10 years ago

I did as you say to connect to the document and was able to see and select the desired Excel file, just not load it.

 

If I do as you suggest, would I still be able to refresh the dataset when published to PowerBI.com?

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi jamieo toulou,

When you connect to Excel file from Sharepoint Online in Power BI Desktop, create PBIX file and publish it to Power BI Service, you are able to schedule refresh for the dataset.

Moreover, OAuth2 is the right protocol for SharePoint Online Excel, there is no other option to connect to the web URL besides those options mentioned by toulou.

Thanks,
Lydia Zhang

  • jamieo's avatar
    jamieo
    Microsoft Employee
    10 years ago

    Lydia, even going this route, the automatic refresh fails.  I can manually refresh through the "Schedule Refresh" interface by manually changing to Oauth and providing credentials, but these credentials are gone the next time I login and any scheduled refresh fails.

     

    Is there any way to get scheduled refresh without using a PowerBI Gateway?

    • Anonymous's avatar
      Anonymous
      Not applicable
      10 years ago

      Hi jamieo,

      No gateway is required in your scenario. Power BI Service directly connect to the Excel file stored in SharePoint Online. What is the exact error message do you get when you schedule refresh?

      Thanks,
      Lydia Zhang

      • jamieo's avatar
        jamieo
        Microsoft Employee
        10 years ago

        Every time I login the credentials appear to revert to "Anonymous" and the error I get during the refresh is:

         

        ```
        Hide details
        Data source type:

        Processing error:
        The key didn't match any rows in the table.
        Cluster URI:
        DF-MSIT-SCUS-redirect.analysis.windows.net
        Activity ID:
        7c0c7083-e50f-4e5b-a0fd-4f06b029db04
        Request ID:
        ed5aa13c-4c61-4fe4-8a33-8db11624f317
        Time:
        2016-08-22 05:21:05Z

        ```

         

        p.s. Is there any way to get markdown to work in these forums?

  • toulou's avatar
    toulou
    Frequent Visitor
    10 years ago
    yes, oAuth2 works. Although I had to open and close the browser a few times because after a few files it wouldn't work anymore. Thank you for your help.