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'm trying to find out what happens if by accident a column is dropped from a source(ie sql server table). I assume the Power BI report will break? As a best practice is it better to use a custom query and select only the columns you need in your model over a direct import? I would think this is the case, to minimize size.
Solved! Go to Solution.
@danman71 , if that column is used in some power query step, DAX column, or measure then it will break a few things.
Best way to remove is: Select all the columns you need and use remove other columns
@danman71 , if that column is used in some power query step, DAX column, or measure then it will break a few things.
Best way to remove is: Select all the columns you need and use remove other columns
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 |
---|---|
111 | |
94 | |
83 | |
67 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |