Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.