Data gateway access error

[SinduN]

I created a dasboard based on direct query on SAP BW and publised on powerbi online. Once I open the dashboard all my tiles have an error "couldnt load teh model schema" with the below technical info

Cannot connect to the gateway data source.
Please try again later or contact support. If you contact support, please provide these details.

Serversapwq1.chdhcl.com

SystemNumber10

Correlation ID063b65ee-f982-286a-6606-fde163d8c428

ClientId100

ConnectionType{FieldValue}

Activity IDcab8ef74-f506-4f45-a290-4f1f78b9d90e

Request ID03604cfe-2c00-59ea-a6bb-46173bce73b2

TimeTue Jul 24 2018 15:37:20 GMT-0400 (Eastern Daylight Time)

Version13.0.6064.124

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

[v-yuta-msft · Accepted solution]

Hi SinduN ,

Please check if data gateway service are working on the server and check if you have updated the gateway to the lastest version. In addtion, check if you have check if you have selected "SSO" in advanced settings and shared your dashboard or report with other people, if you have, you should cancel "SSO" option and refresh again.

Regards,

Jimmy Tao

[SinduN]

Thank you Jimmy,

There are some limitations with Direct Query as in it only shows Text and not Keys from SAP BW and a flat file source cannot be merged. I'm instead looking into the import from BW option. The gateway couldnt be connected to SAP BW. Im working with our infrastructure team to install SAP client tools on Azure server for the gateway connection to be succesful. Hope that will help with the scheduled refresh of the import