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...
Anonymous's avatar
Anonymous
Not applicable
9 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
9 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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi jamieo,

    When entering the account and credential to configure schedule refresh in Power BI Service, do you use the same organization account that is used to connect to SharePoint Online in Power BI Desktop?


    Thanks,
    Lydia Zhang

    • jamieo's avatar
      jamieo
      Microsoft Employee
      9 years ago

      Yes, I couldn't find any other way to generate sharepoint credentials.