Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Power Query only shows first row

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 :

ClementdW_0-1725023749726.png

My Power Query :

ClementdW_1-1725023787857.png

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

Thanks for your help,

Clément

 

4 REPLIES 4
Terraque
Regular Visitor

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.
image.png
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
Not applicable

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
Super User
Super User

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
Not applicable

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 ?

sharepoint-app.png

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.