Forum Discussion
August release: Unable to load the data model
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.
Power BI TeamPower 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!
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.
gemidriverHelper II
Unable to load a report
connection is to SQL DB using Direct Query
Saves to report server, however doesn't load
Something went wrongUnable to load the model
Please try again later or contact support. If you contact support, please provide these details.Request IDd0e0b1d4-13ea-46f5-aab4-4fac5d49157eTimeTue Sep 05 2017 12:09:16 GMT+1000 (AUS Eastern Standard Time)Version14.0.600.379