Forum Discussion
Power Query not identifying all rows from excel unless I resort in excel and save???
I have two excel files that are generated from an Alteryx workflow that obtains information from SAP. These two files are the only data source for a Power BI build. The refresh of these files happens...
Hi,
sorry to resurect this topic but, I have a really similar problem.
I can send an example file and the steps to reproduce.
First de xls file: https://www.manxa.com/01simple.xls
The steps:
1.- open excel (tested on 2019 and 365) with a new blank spreadsheet
2.- goto: data -> get data -> from file -> from excel file
3.- in data preview you only see two cells with text
4.- the same when you finishes de wizard ...
If you opens the file normally, you see some more data ...
Ok, this case is very simple, but it's the same what happens with another xls file with more real data.
Anyone can help us?
Thank's!