Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
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
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
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.
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 ?