Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.