Dataflow Error: Data Source Error : DataSource.Error: SharePoint: Request failed:

[Gungun]

Hi,
I am using dataflow and trying to query data from an Excel file stored on a OneDrive.

Query

let
Source = SharePoint.Files("https://xxxxx-my.sharepoint.com/personal/xx-xxx_xxxx_com/", [ApiVersion = 15]),
  #"Filtered hidden files" = Table.SelectRows(Source, each [Attributes]?[Hidden]? <> true),
  #"Filtered rows" = Table.SelectRows(#"Filtered hidden files", each Text.Contains([Folder Path], "https://xxxxx-my.sharepoint.com/personal/xx-xxx_xxxxx_com/Documents/Daily Executive Report/Supply Report/ZISIMR008/"))

Error:

Error: Data Source Error : DataSource.Error: SharePoint: Request failed: https://xxxxx-my.sharepoint.com/personal/xx-xxx_xxxxx_com/Documents/Daily Executive Report/Supply Report/ZISIMR008/ProductName_YYYYMM_xlsx/_api/contextinfo DataSourceKind = SharePoint DataSourcePath = https://xxxxx-my.sharepoint.com/personal/xx-xxx_xxxxx_com SPRequestGuid = e28b21a0-3077-0000-f150-a5e155c982e6. RootActivityId = 1f966498-5391-48e1-b5eb-dc8e96a07359.Param1 = DataSource.Error: SharePoint: Request failed: https://xxxxx-my.sharepoint.com/personal/xx-xxx_xxxxx_com/Documents/Daily Executive Report/Supply Report/ZISIMR008/ProductName_YYYYMM_xlsx/_api/contextinfo DataSourceKind = SharePoint DataSourcePath = https://xxxxx-my.sharepoint.com/personal/xx-xxx_xxxxx_com SPRequestGuid = e28b21a0-3077-0000-f150-a5e155c982e6 Request ID: 43948f15-ba26-45d8-b28d-32859b6d9619.

I tried to follow by to previous resolutions in this community https://community.powerbi.com/t5/Power-Query/DataSource-Error-SharePoint-Request-failed/m-p/211206#M... and https://powerusers.microsoft.com/t5/Power-Query/DataSource-Error-SharePoint-Request-Failed/m-p/14372...

Please advise for any idea or may I missed something?

Best Regards,
Gun.k

[Gungun]

I applying authentication at OneDrive Personal https://xxxxx-my.sharepoint.com/personal/xx-xxx_xxxxx_com at the Organizational level and the Power BI account is under the same organization should not be any problem I think.

[BA_Pete]

Hi @Gungun ,

At what level are you applying the authentication?

Try and apply authentication at the folder level at least, not at the https://xxxxx-my.sharepoint.com/ or https://xxxxx-my.sharepoint.com/personal/ levels.

Pete