What's the best practice of pulling salesforce formula fields?

[tigernsw]

The formula fields became "record" when pulled.

Any advices are highly appreciated.

[v-ljerr-msft]

Hi @tigernsw,

Have you tried the Salesforce content pack for Power BI?

In addition, here is a similar thread about pulling salesforce data in Power BI for your reference.  

Regards

[tigernsw]

Thanks V.

I have read that thread which API has 2000 limitation.   I haven't tried SF content Pack but seems like Power BI is over complicated for our request at the moment.  So we are going to stick on Power Query as they are same thing but can be used in excel.

I've just discovered the dot -> t issue I have mentioned above.  It was the configure issue in my excel.  It's fixed now.

Thanks both of you for the support.

Regards

Tiger

[v-ljerr-msft]

Hi @tigernsw,

Great to hear it is fixed now! Could you accept your reply above as solution to close this thread, which could also help others who has similar issue easily find the answer. 

Regards

[vanessafvg · Accepted solution]

@tigernsw  have you tried expanding the record?

[mizz22]

I am a bit of a novice on both programs. I believe I have everything expanded ( i am seeing each contract with change order total as well as each individual change order and value under that contract in sales force), but I am still getting "record" and the column from the record is not pulling in. Any idea what could be causing this? 

[tigernsw]

Thx Venessa, Yes, that seems like the quickest way.  Then I have to combine the two columns by using Excel formula, not a big deal but needs further trainings for people without much tech background.

I've also tried Power Query, but the numberic data became wired.   Such as: 442.11 became 442t11

Did you have same expereinces?

[tigernsw]

The formula fields became "record" when pulled.

Any advices are highly appreciated.