Forum Discussion
Columns to rows using live connection to Salesforce objects
Currently I am getting data into columns (for each period a seperate column) when connecting to a certain FinancialForce object in Salesforce. Is there a way to transpose the columns into rows wh...
Hi DuncanHobeijn,
What do you mean about “live connection with Salesforce”? When we get data use salesforce Objects data source in Power BI desktop, only import is supported. After retrieve data in Power BI, you can go to Query Editor-> Transform -> Transpose.
Regards,
Jimmy Tao
Hi Jimmy Tao,
I guess we mean the same. I am operating more on the functional side than the technical ;)
Transpose does not seem to work since I only need the data of a selection of columns to move to rows and not all columns.
Thx, Duncan