when i am trying to execute the job(it executes SSIS file) through sqlagent it works fine but same i am trying to execute the job through MSBI it shows the below error:
[Source - genV_GCDRA_Major_Filings ] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "MSPS-Extension" failed with error code 0xC0202009. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
have you added the username password etc as configuration item? have you created config file with values for local execution in MSBI? Were you the one who created the package originally? Check whats the current protection level set for the package.