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.
Dear friends,
I have data source (I can't change) containing tables as Excel with 2 first rows are merged into group column and the data set is below those 2 lines. My problem is that seems like Power Query might interpret the first two merged rows as headers or as a single block of data, leaving the rest unrecognized.
The issue seems to be happened with only raw file where no changes has been made. If I edit anything or just even re-save the file, the issue is gone. It's quite confusing to me on how to deal with this. I have like 20 files so open and save is still doable but I want a way to work around.
If anyone experience the same issue, please help me.
Thanks and regards,
see this video
https://youtu.be/pofthD7-YuQ
Sorry, the link is private so that I cannot see it.
Hi,
can you post some sample files?
Hi, due to the confidentiality, I cannot share the file. However, I will put 2 screen capture as below:
1. Raw file:
2. Still the raw file but being opened and saved (change nothing inside)
Please help! Thank you
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
7 | |
5 | |
5 | |
5 | |
4 |