cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mtakao01 Frequent Visitor
Frequent Visitor

Gateway connectivity issue - Schedule Refresh not working

Hi,

 

I trying to Schedule a Refresh but I am facing with an issue on my Gateway Connection

 

I have two file that are saved on my One Drive and connected to my Power BI Reports.

 

On the Data Set > Gateway Connection > Status, it appears the message "Not Configured correctly". and below another message like "File{"path":"c:\\users\\xxx\onedrive\file11.xlsx"") 

 

I tried to Add this folder/File to the Gateway  as a Data Source (Sharepoint type)  but it did not worked well.

 

Error Message:

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."Show details

 

 

Activity ID:a1a4818a-a8e9-4e3e-8596-68ba1f2becd8
Request ID:fc0fe161-e7de-28ea-154a-e743d48267e2
Cluster URI:https://wabi-north-europe-redirect.analysis.windows.net
Status code:400
Error Code:DMTS_PublishDatasourceToClusterErrorCode
Time:Mon Feb 18 2019 15:59:53 GMT-0300 (Horário Padrão de Brasília)
Version:13.0.8383.201

 

 

One Drive - ABB:Invalid connection credentials.
Underlying error code:-2147467259
Underlying error message:The credentials provided for the SharePoint source are invalid. (Source at https://abb-my.sharepoint.com/.)
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.CredentialError.DataSourceKind:SharePoint
Microsoft.Data.Mashup.CredentialError.DataSourcePath:https://abb-my.sharepoint.com/
Microsoft.Data.Mashup.CredentialError.Reason:AccessForbidden
Microsoft.Data.Mashup.MashupSecurityException.DataSources:[{"kind":"SharePoint","path":"https://abb-my.sharepoint.com/"}]
Microsoft.Data.Mashup.MashupSecurityException.Reason:AccessForbidden

 

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Gateway connectivity issue - Schedule Refresh not working

Hi there

Could you try and connect to your data via using the Web Connector and if you are using Excel, open the file and then select copy path?

Here are more details: https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

View solution in original post

3 REPLIES 3
Super User
Super User

Re: Gateway connectivity issue - Schedule Refresh not working

Hi there

Could you try and connect to your data via using the Web Connector and if you are using Excel, open the file and then select copy path?

Here are more details: https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

View solution in original post

mtakao01 Frequent Visitor
Frequent Visitor

Re: Gateway connectivity issue - Schedule Refresh not working

many tks!

Super User
Super User

Re: Gateway connectivity issue - Schedule Refresh not working

Thanks for letting me know you got it working, it will certainly help others.

Did I answer your question? Mark my post as a solution!
"Proud to be a Datanaut!"
Power BI Blog

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 79 members 1,264 guests
Please welcome our newest community members: