Forum Discussion
Anonymous
1 year agoNot 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...
Terraque
1 year agoRegular 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.
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
- Anonymous1 year agoNot 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