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.
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
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 |
---|---|
105 | |
101 | |
79 | |
72 | |
64 |
User | Count |
---|---|
141 | |
107 | |
100 | |
82 | |
74 |