Hi,
Here is the scenario:
I have a source excel 'Excel1' stored in Sharepoint online library. In the same site I have another excel workbook ('Excel2') wherein I want to pull complete worksheet data from Excel1 using PowerQuery. Subsequqntly I want to use this data
in 'Excel2' for Powerviews.
Problem is that when I import data into excel2 using import fromxls file, I get the error "DataFormat.Error: External table is not in the expected format."
I was able to do the same few days back and now its not working. Appreciate quick help or any pointers.
Thanks,
Pushkar