Jun 05 2020 08:08 AM
Using Get External Data to connect to a Salesforce report -- all of the fields are fine EXCEPT the value fields which show as "Record" in the query itself and simply don't appear in the table that imports to Excel -- has anyone seen this? I have admin rights to Salesforce, so I don't think this is a data rights issue.
Jun 05 2020 08:32 AM
I didn't work with Saleforce itself, but that's absolutely okay when query returns column of records. Usually that linked to this records table data. You shall transform these records in Power Query. With this records could be lists, etc, - do transformations till you receive what you need as values, remove all unused columns with records and lists and only after that return result to Excel sheet. Keep only values in it.
Jun 05 2020 08:40 AM
@Sergei Baklan Thank you for replying -- did you happen to look at the screen shot I had attached? The columns that should have $values in them simply say "Record" in each cell.
Jun 05 2020 08:47 AM
SolutionOf course. Word Record is aligned to the left, highlighted and clickable.
If you click in the cell on empty space to the right of the word and wait a bit, at the bottom of the screen you will see another window which shows what is within record. It usually list with names and values. However, could be simply null. If click on two-arrows icon on the top right of the column, you expand all records.
Record means that Revenue has not only value inside but some other metadata as well.
Jun 05 2020 08:52 AM
@Sergei Baklan Thank you! That worked perfectly -- the column had both an amount and a currency associated to it!
Jun 05 2020 09:20 AM
@Joanne_Thiel , you are welcome, glad to help
Jun 05 2020 08:47 AM
SolutionOf course. Word Record is aligned to the left, highlighted and clickable.
If you click in the cell on empty space to the right of the word and wait a bit, at the bottom of the screen you will see another window which shows what is within record. It usually list with names and values. However, could be simply null. If click on two-arrows icon on the top right of the column, you expand all records.
Record means that Revenue has not only value inside but some other metadata as well.