Application Insight Gateway configuration issue

[my76]

Hello

I have a created a report using PowerBI Desktop that merges data from 2 data sources (our Salesforce.com data and Application Insights data via an M Query). The windows credentials for each data source are different. Refreshing the data works successfully using PowerBI Desktop. 

The report has been published to PowerBI Service. I want to schedule a daily refresh of the data and have tried to configure the Application Insights data to refresh by adding an entry into our Enterprise Gateway Cluster and this is where I hit a problem because it will not connect. The error message is copied below. 

Any ideas on how to resolve this? 

Thanks in advance
Matt

------

Unable to connect: We encountered an error while trying to connect to . Details: "We could not register this data source for any gateway instances within this cluster. Please find more details below about specific errors for each gateway instance."Hide details

Activity ID:	e857b3bd-4ed8-420e-b3be-a7fa661b700e
Request ID:	52b8319e-9915-5f67-7e54-6ed3fd8ba044
Cluster URI:	https://wabi-west-us-redirect.analysis.windows.net
Status code:	400
Error Code:	DMTS_PublishDatasourceToClusterErrorCode
Time:	Mon May 20 2019 11:29:01 GMT+0100 (British Summer Time)
Version:	13.0.9485.130

Company PROD:	Invalid connection credentials.
Underlying error code:	-2147467259
Underlying error message:	The credentials provided for the Web source are invalid. (Source at https://api.applicationinsights.io/v1/apps/66adbeb0-7ca5-49f7-b5c1-6c28f88a3def/query.)
DM_ErrorDetailNameCode_UnderlyingHResult:	-2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind:	Web
Microsoft.Data.Mashup.CredentialError.DataSourcePath:	https://api.applicationinsights.io/v1/apps/66adbeb0-7ca5-49f7-b5c1-6c28f88a3def/query
Microsoft.Data.Mashup.CredentialError.Reason:	AccessUnauthorized
Microsoft.Data.Mashup.MashupSecurityException.DataSources:	[{"kind":"Web","path":"https://api.applicationinsights.io/v1/apps/66adbeb0-7ca5-49f7-b5c1-6c28f88a3def/query"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason:	AccessUnauthorized

[CoderZen08]

Hi @my76 were you able to find a solution? As a workaround, maybe you can try to test your connection with a 3rd party connector. I've tried windsor.ai, supermetrics and funnel.io. I stayed with windsor because it is much cheaper so just to let you know other options. In case you wonder, to make the connection first search for the Salesforce connector in the data sources list:

After that, just grant access to your Salesforce account using your credentials, then on preview and destination page you will see a preview of your Salesforce fields:

There just select the fields you need. It is also compatible with custom fields and custom objects, so you'll be able to export them through windsor.  Finally, just select PBI as your data destination and finally just copy and paste the url on PBI --> Get Data --> Web --> Paste the url. 

[v-danhe-msft]

Hi @my76 ,

Could you have used any parameters for you data in query editor like bleow code?

let
    A= (path as text) =>

If so, you may not use refresh in service currently, below is an idea of the problem, you could have a view:

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9312540-make-functions-refreshabl...

Also, you may refer to this blog:

https://blog.crossjoin.co.uk/2016/08/23/web-contents-m-functions-and-dataset-refresh-errors-in-power...

Regards,

Daniel He

[my76]

Hi Daniel @v-danhe-msft 

I read the two posts you shared but they have not helped. The problem occurs when the test connection is made in the gateway and I get the previously reported error.

I ran a test with only the application insights data source in a report and was successful in scheduling a refresh using Oauth in PowerBI service (DataSets > Settings > Data Source Credentials). But when I try to add my credentials to the Gateway cluster I do not see an Oauth option. Could this be the problem? 

Thanks

Matt

[my76]

@v-danhe-msft I really need to get this working ASAP. Please can you assist or help me raise a support ticket.

Thank you

Matt

[v-danhe-msft]

Hi @my76 ,

You could create a support ticket in https://powerbi.microsoft.com/en-us/support/

Regards,

Daniel He