power query

TrustPilot

starstarstarstarstar Excellent

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Power Query

Power Query

· High Priority · Version 2016

Wed 21 Aug 2019, 16:24 replyReply Delegate Emineh said...

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

For upcoming training course dates see: Pricing & availability

Thu 22 Aug 2019, 10:39 replyReply Trainer Claire said...

RE: Power Query

Hi Emineh,

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

thanks
Claire

Thu 22 Aug 2019, 15:42 replyReply Trainer Jens said...

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: 0845 5194 797
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

Thu 22 Aug 2019, 15:52 replyReply Delegate Emineh said...

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

Thu 22 Aug 2019, 15:56 replyReply Trainer Jens said...

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: 0845 5194 797
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

Fri 23 Aug 2019, 09:24 replyReply Trainer Jens said...

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: 0845 5194 797
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

 

Live dates & prices

 

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:

Go to source of a cell

The default setting in Excel is when you double click in a cell it actives the formula in the cell. If you have created a link and want to directly go to that link (say if on another sheet, click on Tools -options and take off the tick for eidt it directly in cell

View all Excel hints and tips


TrustPilot
TrustScore 4.9 / 5       1106 reviews