DataSource.Error: SharePoint: Request failed

[EduardoDonato]

Hi,

I am using Power BI Desktop and trying to query data from an Excel file stored on a SharePoint Online site.

let
    Fonte = SharePoint.Files("https://eletromarquez.sharepoint.com/sites/EDPAutomaoeTelecom",[ApiVersion = 15]),
    #"Linhas Filtradas" = Table.SelectRows(Fonte, each Text.StartsWith([Folder Path], "https://eletromarquez.sharepoint.com/sites/EDPAutomaoeTelecom/Documentos Partilhados/Produtividade")),
    #"Linhas Filtradas1" = Table.SelectRows(#"Linhas Filtradas", each ([Extension] = ".xlsx"))
in
    #"Linhas Filtradas1"

I get this intermitent error:

DataSource.Error: SharePoint: Request failed: https://eletromarquez.sharepoint.com/sites/EDPAutomaoeTelecom/Documentos Partilhados/Produtividade/8 - Agosto 2020/Produtividade Agosto 2020 - NAME OF FILE_xlsx/_api/contextinfo
Details:
    DataSourceKind=SharePoint
    DataSourcePath=https://eletromarquez.sharepoint.com/sites/EDPAutomaoeTelecom
    SPRequestGuid=97d2889f-40d6-0000-68ed-304cacb0d4d7

 
Intermitente because sometimes the query works and sometimes don't, besides that the file pointed at error message changes at each error.

Looking for solutions in this forum, I saw that some people had the same issue but with no definitive solution. 
Example: https://community.powerbi.com/t5/Power-Query/DataSource-Error-SharePoint-Request-failed/td-p/210387 

Previous suggestions I've tried and didn't work:
- Update Excel and Power BI (I tried to query in both applications)
- Clear permissions and log in again.


Sorry my bad English,

Best Regards,

Eduardo Donato

[v-alq-msft]

Hi, @EduardoDonato 

I failed to reproduce your scenario. I'd like to suggest you create a support ticket to get faster and better technical support for the issue.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.