My team is having a hard time getting all of our cubes to be able to be used in Power BI. Many work just fine but when we try to connect to others in the desktop we get "An error occurred while loading the model for the item or data source 'QuerySystemError'. Verify that the connection information is correct and that you have permissions to access the data source.
Our DBAs setup a profiler session trying to see if there was anything to give a hint as to why we are getting the error message.
1) Here is the event ID raised on the SSAS server in the Application log at the OS level:
Log Name: Application
Source: MSSQLServerOLAPService
Date: 12/27/2017 9:18:29 AM
Event ID: 22
Task Category: (256)
Level: Error
Keywords: Classic
User: N/A
Computer: XXX
Description:
The description for Event ID 22 from source MSSQLServerOLAPService cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
If the event originated on another computer, the display information had to be saved with the event.
The following information was included with the event:
Internal error: An unexpected exception occurred.
the message resource is present but the message is not found in the string/message table
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQLServerOLAPService" />
<EventID Qualifiers="49408">22</EventID>
<Level>2</Level>
<Task>256</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2017-12-27T15:18:29.000000000Z" />
<EventRecordID>475867</EventRecordID>
<Channel>Application</Channel>
<Computer>XXX</Computer>
<Security />
</System>
<EventData>
<Data>Internal error: An unexpected exception occurred.</Data>
</EventData>
</Event>
2) Here is the error text logged to the msmdsrv.log file on the SSAS server:
(12/27/2017 9:18:30 AM) Message: (Source: \\?\Z:\SQLMountPoint\SQLTLogs\ASLogs\msmdsrv.log, Type: 3, Category: 256, Event ID: 0xC1000016)
3) The file FlightRecorder_20171222.trc was capture and the DBAs noticed Error # -1056964586 while the connection was trying to be made from Power BI Desktop.
What can we do to try to figure out what Power BI doesn't like about this cube?
Thanks
