didijaba
Well-known Member
- Joined
- Nov 26, 2006
- Messages
- 511
HI,
thanks for reading my post, hope you'll have advice how to solve this. I have xls files in sharepoint folder. All files have same structure.
Data in sheets is not in formated tables, so there are text and number cells (general type). Numbers are decimal (example 2.33 shown, in real number is 2.326546678).
When I pull data using Power Query (Excel 2016 64x) numbers become 2.33, and all other is lost?
Any idea how to get full numbers.
Thanks in advance.
thanks for reading my post, hope you'll have advice how to solve this. I have xls files in sharepoint folder. All files have same structure.
Data in sheets is not in formated tables, so there are text and number cells (general type). Numbers are decimal (example 2.33 shown, in real number is 2.326546678).
When I pull data using Power Query (Excel 2016 64x) numbers become 2.33, and all other is lost?
Any idea how to get full numbers.
Thanks in advance.
Code:
let
Source = SharePoint.Files(MAIN_SOURCE, [ApiVersion = 15]),
#"Filtered Rows" = Table.SelectRows(Source, each Text.Contains([Folder Path], "TEST_PQ")),
#"Filtered Rows1" = Table.SelectRows(#"Filtered Rows", each Text.Contains([Name], "_Oriel")),
#"Invoke Custom Function1" = Table.AddColumn(#"Filtered Rows1", "Transform Binary from Query1", each #"Transform Binary from Query1"([Content])),
#"Removed Other Columns1" = Table.SelectColumns(#"Invoke Custom Function1",{"Name", "Transform Binary from Query1"}),
#"Expanded Transform Binary from Query1" = Table.ExpandTableColumn(#"Removed Other Columns1", "Transform Binary from Query1", {"Name", "Data"}, {"Transform Binary from Query1.Name", "Transform Binary from Query1.Data"}),
#"Expanded Transform Binary from Query1.Data" = Table.ExpandTableColumn(#"Expanded Transform Binary from Query1", "Transform Binary from Query1.Data", {"Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9", "Column10", "Column11", "Column12", "Column13", "Column14", "Column15"}, {"Column1", "Column2", "Column3", "Column4", "Column5", "Column6", "Column7", "Column8", "Column9", "Column10", "Column11", "Column12", "Column13", "Column14", "Column15"})
in
#"Expanded Transform Binary from Query1.Data"