Several errors occurred during data refresh

0 votes
Hi guys,

I've placed a report on my Report Server. Users can view this report. But: my scheduled refresh doesn't work. It gives me the error "Several errors occurred during data refresh. Please try again later or contact your administrator."

I've contacted our administrator. He thinks it has something to do with the rights for the Service Account I used. You can see the connection was tested successfully. In my ETL I see that the refresh has started but it seems it can't finish the refresh. And that may be because of the rights for the Service Account.
Nov 16, 2020 in Power BI by anonymous
• 10,520 points
829 views

1 answer to this question.

0 votes

"Connexion successful" mean "the network connection is operational but without any guaranty that the current user can "Read" the source data.

First, check your sa_capp account has "Read" right on the source database. For Microsoft SQL Server Analysis Services, add sa_capp account in a Role with "Read" authorization.

For Live query connexion, you don't need to schedule refresh.

answered Nov 16, 2020 by Gitika
• 65,890 points

Related Questions In Power BI

0 votes
1 answer

Append excel data and In house database data that gets refresh evey 24 hour

Hi, You can try this way, A  -  Actual ...READ MORE

answered Mar 20, 2019 in Power BI by Sindhu
200 views
0 votes
1 answer

How do you schedule Data Refresh in Power BI?

Hi, Following could be the reasons why this ...READ MORE

answered May 21, 2019 in Power BI by Avantika
• 1,520 points
393 views
0 votes
1 answer

Profile all the data tables

you can automatically get a profile for ...READ MORE

answered Sep 20, 2018 in Power BI by Kalgi
• 52,350 points
242 views
0 votes
1 answer

Refresh power bi report every hour

You’ll have a Power BI service option ...READ MORE

answered Sep 24, 2018 in Power BI by Hannah
• 18,570 points
939 views
0 votes
1 answer

Install Power BI Desktop

It’s a pretty simple process. All you ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,350 points
371 views
0 votes
1 answer

Few tips before I start creating Power BI dashboard

It’s always advisable to begin with the data ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,350 points
335 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,350 points
569 views
+1 vote
1 answer
0 votes
1 answer

How to troubleshoot a refresh on data set in power bi service

Hello, @vnk, You may see an error when ...READ MORE

answered Sep 14, 2020 in Power BI by Gitika
• 65,890 points
327 views
0 votes
1 answer

Error Error on Data load when open report in server "An error has occurred"

The problem you can solve by edit this ...READ MORE

answered Nov 16, 2020 in Power BI by Gitika
• 65,890 points
591 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP