98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Power Query
Power Query
Resolved · High Priority · Version 2016
Wed 21 Aug 2019, 16:24Delegate 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
Thu 22 Aug 2019, 10:39Trainer 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:42Trainer 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: 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
Thu 22 Aug 2019, 15:52Delegate 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:56Trainer 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: 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
Fri 23 Aug 2019, 09:24Trainer 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: 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 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
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Separate the year from a dateTo 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) |
