KB45778: "The user running this Report Services document does not have the privilege to access a base report that uses multiple data sources!" error message appears when executing a dashboard imported using a .mstr file

• Strategy

This article details an execution error Specific to MicroStrategy 9.4.1 .mstr files that were created in MicroStrategy Analytics Desktop and imported into web.

SYMPTOM:
As of Strategy 9.4.1 Hotfix 1, .mstr files that were created in Strategy Analytics Desktop can be imported into the Enterprise Platform using Strategy Web. This .mstr file contains both the dashboard and the dataset required by the dashboard.
After importing this dashboard, execution may fail with the following error:


(SQLEngine got an Excepttion from DFC: The user running this Report Services document does not have the privilege to access a base report that uses multiple data sources!Internal Error: DSSDocumentExecuteTask::Run(): Error calling DocumentInstance::Execute() , job 277, Error Code=-2147212800.)

This error may occur even if the dataset used by the dashboard, was created from the import of a single excel file.
CAUSE:
This is a known issue in Strategy Web 9.4.1 Hotfix 1.
ACTION:
Contact Technical Support for an update on this issue.
WORKAROUND:
Grant the affected users the permission: "Execute report that uses multiple data sources":

Comment

0 comments

Details

Knowledge Article

Published:

May 16, 2017

Last Updated:

May 16, 2017