cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bidevsugmen Regular Visitor
Regular Visitor

Scheduled refresh throws error when triggered

The following error is encountered when refresh is triggered.

Screenshot_47.png

 

Data source: SQL Server
The gateway is configured successfully on server.
Data source added successfully in gateway cluster (test connection successful). The server and DB name are same as used in report.
Scheduled refresh successfully.
But the above error is encountered when refresh is triggered (manually/scheduled).

Please suggest workarounds if any. 

5 REPLIES 5
v-jiascu-msft Super Contributor
Super Contributor

Re: Scheduled refresh throws error when triggered

Hi @bidevsugmen,

 

From the error details, it shows the error is invalid connection credentials.

 

Have you refreshed successfully before?

 

Could you create a screenshot to show me if your gateway and the data source have configured well?

b

 

Go to Power BI service ——Settings——Manage Gateways

 

c

 

Best Regards,

Dale

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

Re: Scheduled refresh throws error when triggered

Hi Dale @v-jiascu-msft,

 

The refresh has not happened successfully for this data source/gateway before. It always throws the error- Invalid connection credentials.

Please refer the screenshot below which shows successful connection of gateway with datasource-1.png

Regards,

Suguna.

bidevsugmen Regular Visitor
Regular Visitor

Re: Scheduled refresh throws error when triggered

Hi,

 

Any suggestions/workarounds anyone??

 

Thanks in advance,

Suguna.

Re: Scheduled refresh throws error when triggered

zoloturu
Advisor

Re: Scheduled refresh throws error when triggered

Hi @bidevsugmen,

 

You need to map your Power BI Service & Gateway login with the login of Windows user of the computer where Gateway installed.

In this post, I've explained how to do that - http://community.powerbi.com/t5/Integrations-with-Files-and/Gateway-connected-but-can-not-access-SSA...

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: 6 members 1,429 guests
Please welcome our newest community members: