Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
my76
Frequent Visitor

Application Insight Gateway configuration issue

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
5 REPLIES 5
CoderZen08
Helper III
Helper III

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:

 

SALESFORCE-1.png

 

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:

 

SALESFORCE-2.png

 

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. 

 

SELECT_DESTINATION_NEW.png

v-danhe-msft
Employee
Employee

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

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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
Frequent Visitor

@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

Hi @my76 ,

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

Support Ticket.gif

Regards,

Daniel He

Community Support Team _ Daniel He
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors