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.
Is it possible to Get only a select number of columns in an Excel File without bringing in the entire page to Power BI Desktop? For example, i have an excel file that my coworker updates. on the left side of the excel sheet he has a " raw data " form of data and to the right of that he has tables that have formulas that add up different parts of the "raw data " next t it. is it possible for me to just select the left "raw data" side of the excel file and bring that in without bringing in the full sheet?
Solved! Go to Solution.
Sure, just pull it up in Query Editor, select the columns that you want and then right-click and Remove Other Columns.
Hi @kbrewer,
As what @Greg_Deckler said, when you get data from excel, please select the sheet or table name, then click Edit(highlighted in yellow background), you will go to Edit Quey, you can remove any columns you don't need.
Best Regards,
Angelia
Sure, just pull it up in Query Editor, select the columns that you want and then right-click and Remove Other Columns.
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.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |