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
1,959 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
680 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
897 views
0 votes
0 answers
0 votes
0 answers
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
998 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
864 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
1,209 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
1,002 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
1,521 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