Forum Discussion

VisualJade's avatar
VisualJade
Frequent Visitor
2 years ago
Solved

Get labels for choice cols + Convert Cols to Rows for table visual.

I have 2 questions:  1. How to get labels for choice columns from dataverse/power apps?  Then I need to use these choice columns for below no2.  2. How to convert columns to rows, for 1000+ ...
Need Help
  • VisualJade's avatar
    VisualJade
    2 years ago

    Solved this on my own. I have no access to Azure Data Lake, so I made do. 
    1. Download sample powerbi table from power apps. Copy Paste to PQ code. 
    2. In new PBIX file, paste PQ code for the first table. Create separate tables for each column: A1 - A10 gets TableA; B1 - B10 gets TableB.
    3. Unpivot columns of all tables. The connection will still be in DirectQuery. 
    4. Might want to create a key column for all the tables, ie merge [ID no] & [Col No.] - Col No. being 1 - 10. That way, can connect TableA to TableB via Merged column.

VisualJade's avatar
VisualJade
Frequent Visitor
2 years ago

Solved this on my own. I have no access to Azure Data Lake, so I made do. 
1. Download sample powerbi table from power apps. Copy Paste to PQ code. 
2. In new PBIX file, paste PQ code for the first table. Create separate tables for each column: A1 - A10 gets TableA; B1 - B10 gets TableB.
3. Unpivot columns of all tables. The connection will still be in DirectQuery. 
4. Might want to create a key column for all the tables, ie merge [ID no] & [Col No.] - Col No. being 1 - 10. That way, can connect TableA to TableB via Merged column.