Turn off fields/columns without data
There is a visual indication that directly shows if a column contains any values.
If you click 'edit query', you will see colors in the headers:
• green: has a value
• grey: emtpy
If the bar is totally grey, the column is empty for the first 1000 records.
 | It does not query the whole table, so it is possible there are values in this column, but it is an indication. |
If you have fields that do not contain data, you can do 2 things
1. Do not put them "in use" in Field definer. If you do not put them in use, they will no longer be synced to the data lake and will automatically no longer appear.
2. Remove them from PowerBI (as shown in the following image).
