Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers!
Enter the sweepstakes now!Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.
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
Check out the May 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
74 | |
72 | |
71 | |
50 | |
45 |
User | Count |
---|---|
46 | |
38 | |
29 | |
28 | |
28 |