The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Step 1: Have one list containing columns added to all visuals tracked.
|
Step 2: Have another list containing all of the columns of the model data tracked (separately to the first list).
|
Step 3: Go to Home tab, then in the Queries section, click on Transform Data.
Step 4: Go to Home tab, then in Manage Columns section, click on Remove columns not used in visuals (name pending)
(Behind the scenes)
Columns to keep: (thanks to Step 2) | Columns to remove: |
|
|
Hope this helps.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.