Unbale to load data from xlsx file at sharepoint folder to power bi using data flow.

[Anonymous]

Getting error as below in red icon.

[Anonymous · Accepted solution]

Hi @Anonymous 

This red icon is the step diagnostics indicators, you can refer to this link:

Query folding indicators in Power Query - Power Query | Microsoft Learn

The not-folding indicator tells you that some part of the query up to this step is evaluated outside the data source. You can compare it with the last folding indicator, if there is one, to see if you can rearrange your query to be more performant.

Here's a thread is similar to yours which may help you:

Solved: Re: dataflow gen2 applied steps - red mark - Microsoft Fabric Community

Best Regards

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

[Expiscornovus]

Hi @Anonymous,

That SharePoint folder step loads all the files in a folder. Don't you have any additional steps?

If so, can you share those from the Advanced Editor?

Additionaly, you can hover over the red icon and it should show details of the message in the dialog appearing. Can you share that as well?

Below is an example which loads a single workbook

let
  Source = SharePoint.Files("https://contoso.sharepoint.com/sites/PowerUsers", [ApiVersion = 15]),
  #"Filtered rows" = Table.SelectRows(Source, each ([Extension] = ".xlsx")),
  Navigation = #"Filtered rows"{[Name = "test.xlsx", #"Folder Path" = "https://contoso.sharepoint.com/sites/PowerUsers/Shared Documents/"]}[Content],
  #"Imported Excel workbook" = Excel.Workbook(Navigation, null, true)
in
  #"Imported Excel workbook"