Forum Discussion

DuncanHobeijn's avatar
DuncanHobeijn
New Member
8 years ago

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 whilst keeping the live connection with Salesforce?

 

Thx, Duncan 

Need Help

2 Replies

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support
    8 years ago

    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

     

    • DuncanHobeijn's avatar
      DuncanHobeijn
      New Member
      8 years ago

      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