Power Query only shows first row

[Anonymous]

Hello community !

I am writing this post because I am experiencing a Power Query issue today.

I have a .xlsx source stored on a Sharepoint location, which I would like to use on Power BI. Therefore, in Power BI Desktop, I used the "Get data" --> "Web source" option. I copy-paste the link, and everything seems good until here.

My issue though, is that I only get the first row of the Excel file, whereas I would like to have all the data. I checked in the advanced editor if there were some limitations, but everything seems ok.

Would anyone have an idea on the issue ?

My source, stored on a Sharepoint :

My Power Query :

I do not get any error message or whatever, so it is really strange.

Thanks for your help,

Clément

[Terraque]

Hi,
Did find a solution?

I'm experiencing the same problem with auto created files from a system stored on a shared drive folder, so it doesn't seem limited to SharePoint App.

Example 1: I manually saved the file from the 22nd, with the others remaining as is.

had the same results with one file and folder connections

The folder query:

let
fcc_folder = Folder.Contents(Excel.CurrentWorkbook(){[Name="fcc_folder"]}[Content][Column1]{0}),
date_created_filter = Table.SelectRows(fcc_folder, each Date.IsInPreviousNWeeks([Date accessed], 1)),
keep_binary_and_name = Table.SelectColumns(date_created_filter,{"Content", "Name"}),
transform_binary = Table.TransformColumns(keep_binary_and_name,{{"Content", Excel.Workbook}}),
expand_workbooks = Table.ExpandTableColumn(transform_binary, "Content", {"Name", "Data", "Item", "Kind", "Hidden"}, {"Name.1", "Data", "Item", "Kind", "Hidden"}),
keep_selected_sheets = Table.TransformColumns(Table.SelectColumns(expand_workbooks,{"Data", "Name"}), {{"Data", Table.PromoteHeaders}}),
select_data_columns = List.Select(Table.ColumnNames(Table.Combine(keep_selected_sheets[Data])),each not Text.StartsWith(_,"Col")),
expand_sheets = Table.ExpandTableColumn(keep_selected_sheets, "Data", select_data_columns)
in
expand_sheets

[Anonymous]

Hi Terraque,

Unfortunately I could not find a solution yet. I have to manually edit the file each time it is updated so that I am marked as the "last editor" (and 'Sharepoint app' is not). And then it works. But it is a shame that I have to do that every monday...

So curious if someone has a solution.

Regards,

Clément

[lbendlin]

Therefore, in Power BI Desktop, I used the "Get data" --> "Web source" option

Do not do that.  Use the Sharepoint Folder connector.

Did you select "sheet"  or "table"  as your source ?   Maybe the table definition is limited to a single row.

[Anonymous]

Hi,

I have the same issue using the Sharepoint Folder connector. The selected source is a "sheet".

Weird thing I saw is that when the .xlsx file is updated by a person, I seem to have all data on the Power BI. But when the file is updated by the "Sharepoint App", I only get the first row.

Could that be possible ?