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
I've added an additional columm to the Excel spreadsheet that is my data source, but Power BI isn't (automatically) picking this up when the data is refreshed - viewing the table in Power Query doesn't show this column.
How can I add this extra column please?
Dear ,
1- In your excel , define the data into table and give the table a name ( in Table Design then Table Name ) , in this way everytime you insert a newcolumn it will be included in the table ,
2- check the new column if it is included in the table
3- check in Power Queries in the applied steps if you made remove other columns .
4- Check for error in the table load from the source
Regards,
Kindly accept as a solution and a kudo if it works with you
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 |
---|---|
107 | |
97 | |
75 | |
65 | |
53 |
User | Count |
---|---|
144 | |
103 | |
98 | |
85 | |
64 |