Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
hello !
i have 2 tables (Master and Sub-Master (created by using reference from Master)).
i want to manually add rows in sub-master table using advanced editor but there's an error where :
but as you can see above, there's red line under "Weight" and i hover over the error says invalid identifier, but its weird because "Weight" is available in Master table
@butterscotch
Please share the screenshot of the Source step to ensure the column name is correctly refered. Have you got spaces there?
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
As i said before this table is created by reference from Master table, so i cannot manually add the rows in Excel File because the table isnt visible in the Excel File
Any chance there is some invisible sign in the header?
Otherwise, for me being lazy, I would prefer more "drag and drop" approach to insert data - creating a new table in Power Query and and simple append. It gives me easier control when more rows are about to be added (especially with multiple columns). This approach will also give you a hint, if there is anything wrong with your header.
i got see this method , i must say this is way more simple than what i did , but i just want to challenge myself to do the hard way but anyway thank you for the suggestion , i'll check again is there any typo error in my header name
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
79 | |
67 | |
60 | |
45 | |
45 |