Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

power query

ResolvedVersion 2016

Emineh has attended:
Excel Advanced course
Excel VBA Introduction course
Excel VBA Intermediate course
Excel VBA Advanced course

Power Query

How to connect to power queries in salesfroce

RE: Power Query

Hi Emineh,

I'm passing your question on to Jens, I'm sure he will follow this up shortly.

thanks
Claire

RE: Power Query

Hi Emineh,

Thank you for the forum question and the nice feedback. I am happy that you found the course useful.

It doesn't look like that there is any super solution to what you want. You can connect to the tables in SalesForce but you will need to query the data yourself.

I found one example how to bypass the limitation, but I cannot test it, because I have no access to a SalesForce database.

https://developer.salesforce.com/forums/?id=9060G000000MVUaQAO

I found Power Query Demo With Salesforce, Network Folder video. I do not know if it can help you.

https://www.youtube.com/watch?v=UFzOsNZf3Qo

I hope that you will find a solution.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Power Query

Hi Jans,

Thank you for your help and looking into this for me.

One more thing, I cannot open my course files from yesterday, I think you have it in your USB drive could you please sent them to me?

Many thanks.

Kind regards,
Emineh

RE: Power Query

Hi Emineh,

Yes of course.

Please send an email to:

jens.bonde@stl.training.co.uk

It just to get your email address




Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

RE: Power Query

Hi Emineh,

I found your work email address and I have sent you the files.

Please let me know if you do not get them. It can be your firewall, which stops them.

If you do not get them you may have another email address I can try.


Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Finding cells that have data restrictions

Click anywhere on the worksheet.
On the Edit menu, click Go To.
Click Special.
Click Data validation.
Click All.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.17 secs.