joseph_candava
1 year agoRegular Visitor
Status:
New
How to remove unused visual columns from model data.
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.
No CommentsBe the first to comment
Recent ideas
Not found value "Available gateway clusters"
Hi, Currently the machine (A) hosting power BI on-prime gateway standard. Machine (B) also want to host this server with machine (A). Gateway on (A) and (B) is using the same tenant as admin user. I...Thas_Michael14 hours agoHelper INew7Views1like0CommentsFabric Deployment Pipeline Should Automatically Preserve or Upgrade Semantic Model Compatibility
Category: Microsoft Fabric — Deployment Pipelines | Semantic Models | Direct Lake The Problem When deploying a Direct Lake semantic model containing calculated columns or calculated tables throug...Murtaza_Ghafoor16 hours agoSuper UserNew3Views0likes0CommentsAdd standard ADBC search paths for ADBC drivers in Power BI
Considering the benefits of using ADBC drivers for data intensive operations, it would be nice to allow ADBC drivers to be used that are not necessarily packaged with Power BI installations. To mitig...hsadlier-pdx1 day agoNew MemberNew6Views0likes0Comments