Hi,
I am trying to import one salesforce report from excel by following the below steps.
Open MS Excel, go to Data -> Get Data -> From online service-->From salesforce reports then its navigating to login and then to navigator

There i can only see salesforce report count as 10k and when i search my report it is not dispalying in that list.

I tried to right click on salesforce report and click on load it imported the names of the reports in that i found my report count at 12k. Could you please help me how to import my Salesforce report.

Is there any way to get the profile name of logged in user without querying the user object.

 

I know the following solution:

 

String usrProfileName = [select u.Profile.Name from User u where u.id = :Userinfo.getUserId()].Profile.Name;

 

Instead of this I want to save 1 query so if there is any method to get the profile name in apex without firing the query please let me know.

 

Thanks,