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.
I found a solution to rename column names automatically based on content of a certain column using the following command:
#"Renamed Columns" = Table.RenameColumns(Source,{{"Value", Source[ReportDate]{0}}}),
Although this works, if also screws up the tables because the "name reference" will change. This results in the following error/problem:Before i had dates 22 and 23. After updating i have dates 22 and 24. Because 23 changed to 24, Power Bi doenst reconizes the value to use anymore. Is this possible to fix using some other lines of code?
Solved! Go to Solution.
Hi @Sander123,
By my test and confirmed, this is a limitation in Power BI currently.
When we refer to other values to rename the column name which option is complex, we will encountr this error. We only to click "Fix this" and drag the column again.
Best Regards,
Cherry
Hi @Sander123,
By my test and confirmed, this is a limitation in Power BI currently.
When we refer to other values to rename the column name which option is complex, we will encountr this error. We only to click "Fix this" and drag the column again.
Best Regards,
Cherry
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |