Power BI allow users to map fields from source to Power BI

[jzellman]

My users receive files with the columns in various orders. Each input is in a different order. Is there a way to allow the users to assign their source files fields to the fields in my Power BI?

For example;
My Power BI table (columns Acct Number, Dept, Hours, Dollars)
Users' file column order is (Dollars, Acct Number, Hours, Dept)

Any way to allow a parameter query or something else where the user would map this over?

Thanks

 

[sandy666]

you mean like this?

Your file	Acct Number	Dept	Hours	Dollars
User1	Dollars	Acct Number	Dept	Hours
User2	Hours	Dollars	Acct Number	Dept
User3	Dept	Hours	Dollars	Acct Number

 

[sandy666]

INDIRECT Table2					User Table1
Acct Number	Dept	Hours	Dollars		Dollars	Acct Number	Dept	Hours
Dollars	Acct Number	Dept	Hours		Dollars User	Act User	Dept User	Hrs User
					YoursAfter
					Acct Number	Dept	Hours	Dollars
					Act User	Dept User	Hrs User	Dollars User

// Table2
let
    Source = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Acct Number", type text}, {"Dept", type text}, {"Hours", type text}, {"Dollars", type text}})
in
    #"Changed Type"

// Table1
let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content]
in
    Source

// Append1
let
    Source = Table.Combine({Table2, Table1}),
    #"Removed Top Rows" = Table.Skip(Source,1)
in
    #"Removed Top Rows"