Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi
I'm bringing in an excel file (which definitely has many rows of data!) but when I try to bring it into powerquery I see the below. No rows of data visible, ony the headers.
The report works for other files I bring in, just not this one. Any thoughts?
Solved! Go to Solution.
maybe that excel is corrupted or incompatible, can you check the version or click on refresh button above. try to save another copy of excel, save it by another name and then import. check the file format.
maybe that excel is corrupted or incompatible, can you check the version or click on refresh button above. try to save another copy of excel, save it by another name and then import. check the file format.
Yes, okay, not sure exactly what the issue was, as the excel seemed to work fine. But I threw it into a blank workbook, saved with same filenmame, and now the powerquery picks it up no issues.
Can you make the data on the worksheet a proper table, and then try again?
--Nate