The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi @flamious96
After testing, the sheet can display other columns in my power query.
You can consider to set the data as a table in the sheet, then import it to Power BI Desktop.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is file i use to upload, kindly help to advise, many thanks