Forum Discussion
Data format error. external table is no tin the expected format for (.xls file format)
Hello, from power automate every day a file is created in .xls format. and this file is connected o power query editor(other excel) in sharepoint. But if I save same file in .xlsx format it works. ...
Anonymous , based on your suggestion, using csv Mcode I replaced csv with xls. then complete sheet data is converted in the form of html coding. As shown below
Mcode:-
#"Imported CSV" = Csv.Document(#"Dashboard 2021 has completed xls_https:// sharepoint com/teams/ Report - Flow/Excel_file_Renamed/",[Delimiter=";", Columns=44, Encoding=1252, QuoteStyle=QuoteStyle.None]),
Hi Mate,
Im afraid I have no other ideas currently.
Without access or correct schematics of connecctions, I do not know what else to suggest.