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.
I'm importing a local Excel file (.csv) to Power BI. It has 13 million rows but it's less than 1 GB.
When I open the imported dataset, I only see the top left corner of the data (rows A1-A17). I can't figure out how to see the complete dataset. It only recognizes one of the fields (A10). I need it to find all of the field headers in A10-F10 so I can filter the results to see only what I need.
The ultimate goal is to filter my results down significantly, and then download the smaller dataset so I can actually open it in Excel.
Any help is greatly appreciated! Thanks so much.
Solved! Go to Solution.
When you go to the Edit Queries Mode, You can go to the Home Tab ans select choose columns to see alll the avaialble columns in your dataset. See the attached screenshots for more information.
Hi @Elli,
Please help to post a screenshot about your sceanrio. Besides, would you mind sharing me the Excel file/ I will test it in my Desktop.
Thanks,
Lydia Zhang
When you go to the Edit Queries Mode, You can go to the Home Tab ans select choose columns to see alll the avaialble columns in your dataset. See the attached screenshots for more information.
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.