Azure Analysis Services - Report not working in PowerBI service (but working fine in desktop)

[AbhayChauhan]

I have created a basic report on top of tabular model cube hosted in Azure Analysis services. The report is working as expected in PowerBi desktop. I have published it and I get following error when I open it:

Technical details of error:

Couldn't load the schema for the database model

We couldn't retrieve the data model for this report. Please try again later.
Please try again later or contact support. If you contact support, please provide these details.

Activity ID70446ba8-1777-1b6f-85e7-b1d9a5823142

Request ID6eeff55a-3aab-8ee1-6051-71b29f77af6a

Correlation ID4b0588ec-1606-3452-766a-a8d7e37849e8

TimeFri Feb 24 2017 14:58:59 GMT+0530 (India Standard Time)

Version13.0.1700.1204

Cluster URIhttps://wabi-us-east2-redirect.analysis.windows.net

I also tried creating a data source for azure analysis service cube in enterprise gateway but I am getting following error:

Unable to connect: We encountered an error while trying to connect to asazure://aspaaseastus2.asazure.windows.net/ssasxxxxx. Details: "We reached the data gateway, but the gateway can't access the on-premises data source.

Activity ID:	70446ba8-1777-1b6f-85e7-b1d9a5823142
Request ID:	f9b749fd-890a-caa0-a352-91566551aec5
Cluster URI:	https://wabi-us-east2-redirect.analysis.windows.net
Status code:	400
Error Code:	DM_GWPipeline_Gateway_DataSourceAccessError
Time:	Fri Feb 24 2017 15:01:00 GMT+0530 (India Standard Time)
Version:	13.0.1700.1204

Thanks in advance!!

[Seth_C_Bauer]

@AbhayChauhan Do you have the latest On Premises Data Gateway installed? (Was Enterprise Gateway)

And does the data source connection match exactly in the PBIX compared to the data source  - I assume "yes"

[AbhayChauhan]

@Seth_C_BauerYes, I have latest On Premises Data Gateway installed. I am getting error while trying to add data source to gateway. I have mentioned the error "DM_GWPipeline_Gateway_DataSourceAccessError" in my post.

[Anonymous]

Hi @AbhayChauhan,

If you use the azure analysis service as the datasource, you need to sign-in a on-premise gateway with your azure service url, after you publish the report to service side, it will use "connect directly" mode to connect.

>>I have mentioned the error "DM_GWPipeline_Gateway_DataSourceAccessError" in my post.

Based on your error message, I'd like to suggest you check the state of on-premise gateway, ensure the gateway and its service are running smooth.

For detail informationm you can refer to below article:

On-premises data gateway

Regards,

Xiaoxin Sheng