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 15, 2020 in Power BI by anonymous
• 10,420 points
206 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 15, 2020 by Gitika
• 65,870 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
83 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,500 points
187 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,290 points
102 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,550 points
629 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,290 points
201 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,290 points
168 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,290 points
214 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,870 points
84 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 15, 2020 in Power BI by Gitika
• 65,870 points
57 views