Analysis Services On-premise Data Gateway - Couldn't load the model schema - not all users affected

[aaronlebato]

SQL Server 2016 Analysis Services, On-premise data gateway to Power BI Service.

So I have a bunch of data sources in the Power BI Service that are pointed to SSAS cubes.  I have 1 cube in particular that seems to be always giving me problems but at the same time I'm not sure if it's just something going on with the Power BI Service / Data Gateway.  Right now, in both Microsoft Edge and Internet Explorer, I am not able to access this particular connection.  However, at the very same time, I have other coworkers that are having no issues accessing it.  This appears to affect different users at different times.  Yesterday it was the VP of Sales while I was accessing it just fine.  I'm also able to connect to the cube directly in Excel outside of Power BI just fine.  The cube is functioning fine but the data connection to the cube over the On-Premise gateway seems to have a mind of its own.

Usually, if I reprocess the cube it comes back up...at least for a little while.  Obviously this isn't cool.  Suggestions???

[aaronlebato · Accepted solution]

Although I don't have all of the details (I wasn't the person who solved the issue), it appears this issue was related to conflicting permission levels in Power BI inside of Office 365.  Something to do with different permissions between the dashboards and the apps inside of Office 365.  Since we made the changes there, the issues seem to have stopped.

[GilbertQ]

Hi @aaronlebato

From your description it would appear to me that possibly the server where the On-Premise Data Gateway is running could be the potential bottleneck?

If you cube is fine when accessing it locally then the cube & it's associated hardware appears to be fine.

What I would suggest doing, is using the counters via Performance Monitor and view it to see not only the overall performance of the Server, but also the On-Premise Data Gateway counters. This would include things like bandwidth, CPU, Memory (which is what the On-Premise Data Gateway needs)

Here is a document explaing how to use the Counters, just scroll down to the section called "Performance"

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot