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 am currently connecting to a SQL database to support my dashboards.
When there is a column added, the additive data flows right into PBI is available - and works great. However, (and obviously), when a developer changes a name of a column, or removes a column, the dashboards "break".
When this occurs, what is the best way in Power BI to resolve the changes without rebuilding the dashboard. A brief narrative that explains where to make the change in PBI, and how, would be greatly appreciated.
Please give an example of:
1. Column Name Change
2. Column Removed
Thank you!
Hi @irnm8dn,
When a developer changes a name of a column, or removes a column, you'll need to firstly rename the corresponding names or remove the column name within Advanced Editor in Query Editor.
And then rename the names or remove the column name in your related DAX formulas(measures and calculate columns).
Regards
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 |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |