power query

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

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

Power Query

resolvedResolved · High Priority · Version 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:

Separate the year from a date

To separate the year from a date use the =year() function, eg a date is in cell A1 and in A2 you wish to display the year enter the function =year(A1)

View all Excel hints and tips


Server loaded in 0.06 secs.