I have downloaded the August release (14.0.600.379) and created a simple report against a sql database (with Power BI Desktop 2.49.4831.801), deployment of the report to the report server was successful. However when I try to load the report in the browser I get the error message: The Analysis Server instance has experienced an error and is not available. Please contact your system administrator.Anforderungs-ID49e6e70b-66e5-f8f3-60d1-586d71dc5decStatuscode500ZeitMon Aug 28 2017 17:12:42 GMT+0200 (W. Europe Daylight Time)Version14.0.600.379 I'm a bit puzzled since I don't have a connection to SSAS data in the report at all.

I found now the problem, seems to be a common issue within our company with SSRS, reason is that some local policies are not set for the service account: Adjust Memory quotas for processIncrease a process working setLock pages in MemorySo created a domain service account, set the GPO for this service account that give the necessary privileges. Not sure if the SSRS installer could fix that, or at least during installation give a warning if the necessary privileges are missing.

August release: Unable to load the data model

7 Replies

mgmeyer
Power BI Team
9 years ago
Power BI uses embedded Analysis Services data models internally to host your data, unless you are pointing to a live analysis services server. Since you mention you created your report against a SQL DB your likely using the embedded model which is a new feature in teh August preview. Can you check the RSPowerBIXXX.log and RSHostingServiceXXX.log in the following folder and let me know is you see any errors:

C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles

Thanks!
- TinHau
  Frequent Visitor
  9 years ago
  msmdsrv.log
  
  (29.08.2017 07:47:34) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210019)
  (29.08.2017 07:47:34) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210019)
  (29.08.2017 07:47:34) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x4121000A)
  (29.08.2017 07:47:34) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x4121000A)
  (29.08.2017 07:47:34) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x4121000A)
  (29.08.2017 07:47:34) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x4121000A)
  (29.08.2017 07:47:34) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x4121000A)
  (29.08.2017 07:47:34) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x4121000B)
  (29.08.2017 07:47:34) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210019)
  (8/29/2017 7:47:34 AM) Message: The Vertipaq thread pool now has 2 minimum threads, 2 maximum threads, and a concurrency of -1. Its thread pool affinity mask is 0x0000000000000003. (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x4121000A)
  (8/29/2017 7:47:34 AM) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 286, Event ID: 0x411E0015)
  (8/29/2017 7:47:34 AM) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 286, Event ID: 0x411E000F)
  (8/29/2017 7:47:34 AM) Message: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 286, Event ID: 0x411E0016)
  (8/29/2017 7:47:34 AM) Message: The flight recorder snapshot definition file 'C:\Program Files\Microsoft Power BI Report Server\PBIRS\ASEngine\FlightRecorderSnapshotDef.xml' was not found, skipping initialization of snapshot activity. (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210048)
  (8/29/2017 7:47:34 AM) Message: The flight recorder was started. (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210005)
  (8/29/2017 7:47:34 AM) Message: Cannot start the server in Tabular mode as the needed privilege for memory locking is not held (SE_INC_WORKING_SET_NAME or SE_INC_BASE_PRIORITY_NAME, depending on your operating system version) (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210025)
  (8/29/2017 7:47:34 AM) Message: The service cannot be started: The following system error occurred: (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 3, Category: 289, Event ID: 0xC1210000)
  (8/29/2017 7:47:34 AM) Message: Service stopped. (Source: \\?\C:\Program Files\Microsoft Power BI Report Server\PBIRS\LogFiles\msmdsrv.log, Type: 1, Category: 289, Event ID: 0x41210001)
  
  RSHostingService.log
  
  2017-08-29 07:45:22.4954|INFO|4|Launching Process : Management Service
  2017-08-29 07:45:22.5110|INFO|4|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\Management\RSManagement.exe
  2017-08-29 07:45:56.9330|INFO|11|Fetched ManagementState from Management state = Valid, Encryption key present = True
  2017-08-29 07:45:56.9955|INFO|11|CFG : ASPort = [5132] (switch)
  2017-08-29 07:45:56.9955|INFO|11|Launching Process : RS Service
  2017-08-29 07:45:56.9955|INFO|11|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer\bin\ReportingServicesService.exe
  2017-08-29 07:45:57.1830|INFO|11|Launching Process : Portal
  2017-08-29 07:45:57.1830|INFO|11|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\Portal\RSPortal.exe
  2017-08-29 07:45:57.2455|INFO|11|Launching Process : PowerBI
  2017-08-29 07:45:57.2455|INFO|11|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\PowerBI\RSPowerBI.exe
  2017-08-29 07:45:57.3080|INFO|11|Launching Process : Office
  2017-08-29 07:45:57.3080|INFO|11|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\Office\RSOffice.exe
  2017-08-29 07:46:00.1674|INFO|5|Service watchdog: starting
  2017-08-29 07:46:03.0736|WARN|12|Child Process [AS] Died. Check the log for further information
  2017-08-29 07:46:03.0892|INFO|12|Immediate restart of process AS
  2017-08-29 07:46:04.9330|WARN|12|Child Process [AS] Died. Check the log for further information
  2017-08-29 07:46:33.0737|INFO|4|Throttled restart of process by 28'140.60ms: AS
  2017-08-29 07:46:34.9019|WARN|15|Child Process [AS] Died. Check the log for further information
  2017-08-29 07:47:01.6050|WARN|11|Child Process [Portal] Died. Check the log for further information
  2017-08-29 07:47:01.6050|INFO|11|Immediate restart of process Portal
  2017-08-29 07:47:01.6050|INFO|11|Launching Process : Portal
  2017-08-29 07:47:01.6050|INFO|11|Starting Process: C:\Program Files\Microsoft Power BI Report Server\PBIRS\Portal\RSPortal.exe
  2017-08-29 07:47:33.0896|INFO|7|Throttled restart of process by 58'171.87ms: AS
  2017-08-29 07:47:34.9498|WARN|18|Child Process [AS] Died. Check the log for further information
  2017-08-29 07:49:33.1421|INFO|4|Throttled restart of process by 118'139.81ms: AS
  2017-08-29 07:49:34.9554|WARN|24|Child Process [AS] Died. Check the log for further information
  2017-08-29 07:53:33.2303|INFO|4|Throttled restart of process by 238'186.72ms: AS
  2017-08-29 07:53:35.0742|WARN|34|Child Process [AS] Died. Check the log for further information
  
  Based on this information I did look up Local Security Policy - Increase a process working set:
  - Administrators
  - LOCAL SERVICE
  - Window Manager\Window Manager Group
  
  however the button to add User or Group is greyed out. PBIRS runs under NT SERVICE\PowerBIReportServer
- TinHau
  Frequent Visitor
  9 years ago
  I found now the problem, seems to be a common issue within our company with SSRS, reason is that some local policies are not set for the service account:
  
  Adjust Memory quotas for process
  Increase a process working set
  Lock pages in Memory
  So created a domain service account, set the GPO for this service account that give the necessary privileges. Not sure if the SSRS installer could fix that, or at least during installation give a warning if the necessary privileges are missing.
  - gemidriver
    Helper II
    8 years ago
    Unable to load a report
    connection is to SQL DB using Direct Query
    Saves to report server, however doesn't load
    
    Something went wrong
    
    Unable to load the model
    Please try again later or contact support. If you contact support, please provide these details.
    Request IDd0e0b1d4-13ea-46f5-aab4-4fac5d49157e
    TimeTue Sep 05 2017 12:09:16 GMT+1000 (AUS Eastern Standard Time)
    Version14.0.600.379
mikebrunak
Advocate II
9 years ago
Just so you know I had the exact same error occuring today.

Michael
xpherion
Advocate II
9 years ago
Are you using direct query with SQL Server database? I have created report with excel and Teradata import without any problem.
- TinHau
  Frequent Visitor
  9 years ago
  Nope, with imported data, the Power BI Report Server is running on Window 6.3.9600 (Win2012 R2) with 8 GB RAM

Forum Discussion

August release: Unable to load the data model

7 Replies

Related content

Unable to connect to Google BigQuery data source (August 2025 build)

'Refresh Preview' missing from Power BI Desktop, Power Query August 2025 release

On-premises data gateway August 2025 release

Unable to drag text box in March 2026 release

On-premises data gateway August 2026 release