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,
2 question:
1. When I add custom column in loaded data to excel worksheet I don't see this column in power query, why?
2. Where I should add custom columns to loaded data or power query editor? what is the difference ? (calculation time and etc.)
Thanks !!
Where did you add the column? If you did inside Power Query then you should see it there. If you added it in Power Pivot then it is "too late".
Power Query is used to load the data from a source into the Power Pivot model inside Excel.
It really depends what you want to do with the data in that column. If you want to do further transformations you should do it in PQ. Generally, it's much easier to do it there. In case you need it to do more complex calculations PowerPivot probably is the better place.
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 |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |